How can I type ' 1 - 2 ' in a cell and not get 37988?!
P Paul Corrado Oct 21, 2004 #3 Unfortunately, XL assumes you are entering a date. To get around that start with either a ' if it is text and you want "1-2" to appear in the cell, or an = if you want the numbers to be subtracted.
Unfortunately, XL assumes you are entering a date. To get around that start with either a ' if it is text and you want "1-2" to appear in the cell, or an = if you want the numbers to be subtracted.
R Ron Rosenfeld Oct 21, 2004 #5 How can I type ' 1 - 2 ' in a cell and not get 37988?! Click to expand... 1. Precede by a single quote: '1 - 2 or 2. First format the cell as Text --ron
How can I type ' 1 - 2 ' in a cell and not get 37988?! Click to expand... 1. Precede by a single quote: '1 - 2 or 2. First format the cell as Text --ron