Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
search for latest date | Excel Worksheet Functions | |||
Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
extract date from the most current date | Excel Discussion (Misc queries) |