Date format default problem
On Mon, 21 Nov 2005 07:26:06 -0800, "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.
It depends on what you what to do.
If you want to enter it as a string, then pre-format the cell as text; or
precede your entry with an apostrophe (single quote) or a <space.
If you want to enter it as a fraction, then enter it as 0 2/2668
--ron
|