| 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) | |||
Linear Mode
