View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default 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