how to force excel not to change date?
You could either:
Preformat the cell as text (format|cells|number tab|Text), then do the data
entry.
Or you could prefix your entry with an apostrophe:
'3-4
tgi wrote:
I want the cell to have 3-4 but it keeps changing it to 4-Mar.
--
Dave Peterson
|