| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why do some dates turn to ######
I use Excel to post results of training. Some entries need dates when test
was taken, but when I put in date 10/30/06 it appears as ######. How can I get actual date to appear? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why do some dates turn to ######
Hi
Try widening the column. -- Regards Roger Govier "Gyzmo" wrote in message ... I use Excel to post results of training. Some entries need dates when test was taken, but when I put in date 10/30/06 it appears as ######. How can I get actual date to appear? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why do some dates turn to ######
The column may not be wide enough. Try widdening the columns.
Biff "Gyzmo" wrote in message ... I use Excel to post results of training. Some entries need dates when test was taken, but when I put in date 10/30/06 it appears as ######. How can I get actual date to appear? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why do some dates turn to ######
If it's a date, try widening the column or decreasing the size of the font.
Gyzmo wrote: I use Excel to post results of training. Some entries need dates when test was taken, but when I put in date 10/30/06 it appears as ######. How can I get actual date to appear? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why do some dates turn to ######
Thanks all three of you for the correct answer. Never gave that obvious
answer. I am copying and pasting rows from another report and I guess my format over road theirs. Thanks again. "Dave Peterson" wrote: If it's a date, try widening the column or decreasing the size of the font. Gyzmo wrote: I use Excel to post results of training. Some entries need dates when test was taken, but when I put in date 10/30/06 it appears as ######. How can I get actual date to appear? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to add dates. | Excel Worksheet Functions | |||
| Pre-1900 dates | Excel Discussion (Misc queries) | |||
| Automatic shading of cells based on dates??? | Excel Worksheet Functions | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Linear Mode
