Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
The Serial # is showing and not the actual date
For some reason, the serial number is showing and not the actual date. How
do I change it back to show the date? I have tried to format the colomns, but it still shows the serial number. When I cllick on the number it shows the correct date in the formal bar. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
The Serial # is showing and not the actual date
Try pressing CTRL-` (accent grave - on the same key as the tilde above
the tab key on a US keyboard). In article , kris wrote: For some reason, the serial number is showing and not the actual date. How do I change it back to show the date? I have tried to format the colomns, but it still shows the serial number. When I cllick on the number it shows the correct date in the formal bar. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
The Serial # is showing and not the actual date
Ohhhhh, Thank you so much, I've been trying to change it for over an hour.
"JE McGimpsey" wrote: Try pressing CTRL-` (accent grave - on the same key as the tilde above the tab key on a US keyboard). In article , kris wrote: For some reason, the serial number is showing and not the actual date. How do I change it back to show the date? I have tried to format the colomns, but it still shows the serial number. When I cllick on the number it shows the correct date in the formal bar. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table showing number "1" instead of actual result | Excel Discussion (Misc queries) | |||
Switching Between Showing Formula Or Actual Result In A Cell ? | New Users to Excel | |||
How do I convert Date serial number to date | Excel Worksheet Functions | |||
& reference answering as Date Serial # not actual text | Excel Worksheet Functions | |||
Spreadsheet is only showing formulas not the actual values | Excel Worksheet Functions |