J
Jennifer
How can I type ' 1 - 2 ' in a cell and not get 37988?!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Steve
Hi Jenifer
Format the cell as text or enter as '1-2
HTH
Steve
Format the cell as text or enter as '1-2
HTH
Steve
P
Paul Corrado
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.
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.
A
Arvi Laanemets
Hi
Format the call as text before
Arvi Laanemets
Format the call as text before
Arvi Laanemets
R
Ron Rosenfeld
How can I type ' 1 - 2 ' in a cell and not get 37988?!
1. Precede by a single quote:
'1 - 2
or
2. First format the cell as Text
--ron