View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dale_C141
 
Posts: n/a
Default How do I fix a date format error in Excel?

Excel 2003. I'm entering data into a spreadsheet that has the date as the
first column. It worked fine for 50 columns, using the 01-Mar-06 date format.
Suddenly in column 51, after entering the next date (11 May 06) and pressing
tab to move to the next column, the date displayed as "#########" instead of
"11-May-06." I tried re-formatting the one cell and the entire column. The
correctly-displayed dates through column 50 still looked good, but no matter
what I tried from the formatting menu column 51 and later return the multiple
number signs instead of a date. What's up?