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

Widen the column?

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Dale_C141" wrote in message
...
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?