Date format default problem
preformat the cell as text (format|Cells|number tab|Text)
or prefix your entry with an apostrophe:
'02/2668
Hood wrote:
If I type a serial 02/2668 into Excel it gets confused and thinks it is
February in the year 2668. This then confuses me. Is there a way of
straightening the matter.
--
Dave Peterson
|