View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Controlfreak Controlfreak is offline
external usenet poster
 
Posts: 3
Default date formating problems

This problem has started.

When I key in a number into cell and format as date, it now treats the
number like it were a Julian date. I have opened old spreadsheet that are
formatted as dates, then have keyed into an open cell, a number and format as
a date, and it displays it as a Julian date.