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" <Ninabean@discussions.microsoft.com> wrote in message
news:C6445E30-09DE-49EB-B767-7720474B0FBD@microsoft.com...
>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" <Ninabean@discussions.microsoft.com> wrote in message
> news:C6445E30-09DE-49EB-B767-7720474B0FBD@microsoft.com...
> >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...

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
>
>

What was the problem?

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

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
>
>
>