what does it mean when the date is nothing but #######?
 

I am using the invoice template and all of a sudden today, it is not showing
the date. I have tried to delete it and type in the date again, but it isn't
doing anything. How do I fix it to show the date?

It's a negative date. Go to tools|options|calculation and check the 1904
date system. Hopefully this will cure the problem.

--
Ian
--
"Ninabean" wrote in message
...
I am using the invoice template and all of a sudden today, it is not
showing
the date. I have tried to delete it and type in the date again, but it
isn't
doing anything. How do I fix it to show the date?

It didn't do anything! What next?

"Ian" wrote:

It's a negative date. Go to tools|options|calculation and check the 1904
date system. Hopefully this will cure the problem.

--
Ian
--
"Ninabean" wrote in message
...
I am using the invoice template and all of a sudden today, it is not
showing
the date. I have tried to delete it and type in the date again, but it
isn't
doing anything. How do I fix it to show the date?

Try making the column a little wider or the font smaller...


--
coreman
------------------------------------------------------------------------
coreman's Profile: http://www.excelforum.com/member.php...o&userid=27160
View this thread: http://www.excelforum.com/showthread...hreadid=466785

that didn't work either

"Stephen Bullen" wrote:

Hi Ninabean,

Make the column wider?

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev

I figured it out...Thanks!

"coreman" wrote:


Try making the column a little wider or the font smaller...


--
coreman
------------------------------------------------------------------------
coreman's Profile: http://www.excelforum.com/member.php...o&userid=27160
View this thread: http://www.excelforum.com/showthread...hreadid=466785

Hi Ninabean,

Make the column wider?

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev

What was the problem?


--
coreman
------------------------------------------------------------------------
coreman's Profile: http://www.excelforum.com/member.php...o&userid=27160
View this thread: http://www.excelforum.com/showthread...hreadid=466785