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

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.



"Lisa" wrote:

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?

Thanks. Its annoying that it was something so simple. That's been bothering
me for weeks!!
Strange place to try and pick up...

"Jako" wrote:

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.



"Lisa" wrote:

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?

Thank you. That did work and I feel silly cause it took me so long to fid out
something so simple :)

"Paul B" wrote:

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

Or change the font size <vbg

Lisa wrote:

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?

--

Dave Peterson

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
"Lisa" wrote in message
...
Thank you. That did work and I feel silly cause it took me so long to fid
out
something so simple :)

"Paul B" wrote:

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