Stop interpreting Value as date.

[Rod Jones]

Is there any way to stop MS Excel from automaticaly
changing a value in a cell such as "02-04" to "2 April".
Even if I format the cell as text, the value becomes the
date serial value for "02-04".

 

[Andy B]

Hi

Either format the cell as text before you enter the information, or put a
single apostrophe ' before you type it in.

Hope this helps.

 

[macropod]

Hi Rod,

You can do this by typing a single quote mark ahead of the input string, eg
'02-04. The quote mark won't show, but the cell will correctly display as a
text entry.

Alternatively, if the 02-04 is meant to be interpreted as a number, simply
type in 0204 (or just 204) and use a custom format to display it as 02-04.
The custom format for this would be: 00-00

Cheers