enable/disable auto-convert a NUMBER to DATE
Hi,
I'm a bit surprised that Excel is interpreting 3.8 as a date but if it is
the only way i can replicate it is if somehow you have managed to get an
autocurrect option set for changing . to / so try this.
Tools|Autocorrect options
Type . in the replace box and if anything comes up in the replace-with box
delete the entry.
Mike
"Harry Nopter" wrote:
When I insert a decimal number (e.g. 3.8) in a cell, then it is automatically
shown as a date (e.g. 3-Aug-09), even if I put the number's format (at "cell
format") in the number or in the general format option. I have the 2003
Office. How can I disable this automatic feature?
|