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