typing the date in a cell in excel and ###### comes up instead

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to put the date in to a cell in excel. It worked for the months of
July but when I try to put in August dates it just comes up with ######
instead of 08-Aug-07. Help anyone?
 
Lisa, try and widen the column

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Lisa,

You have to widen the cell by draging it from the top.
Or Right click cell, select Format, click Date, and finaly select the
style you want to use.

Sexy name,
Hope this works.
 
Thanks. Its annoying that it was something so simple. That's been bothering
me for weeks!!
Strange place to try and pick up...
 
Thank you. That did work and I feel silly cause it took me so long to fid out
something so simple :)
 
Or change the font size <vbg>
I'm trying to put the date in to a cell in excel. It worked for the months of
July but when I try to put in August dates it just comes up with ######
instead of 08-Aug-07. Help anyone?
Click to expand...
 
Sometime it's the simple things that trip you up.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Back
Top