Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell that is formated for Date shows a diffrent number
I have an Excel form with a Cell that you need to input sale date that I
input my self. The cell changes from example (12/1/2009) to 32453, but once you double click on the cell it show the hidden (12/1/2009) once you click out of it, it revets to the 32453 number. I check the cell format and it show as date. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell that is formated for Date shows a diffrent number
This sounds very odd because 32453 = 11/6/1988 and not 12/1/2009
Micky "Haider" wrote: I have an Excel form with a Cell that you need to input sale date that I input my self. The cell changes from example (12/1/2009) to 32453, but once you double click on the cell it show the hidden (12/1/2009) once you click out of it, it revets to the 32453 number. I check the cell format and it show as date. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell that is formated for Date shows a diffrent number
You're looking at formulas.
In xl2003 menus: tools|options|view tab|uncheck formulas I don't recall where under the Office button|excel options this is kept, but... ctrl-` (control-backquote, the key to the left of the 1/! on my USA keyboard) is the shortcut key for toggling this setting. Haider wrote: I have an Excel form with a Cell that you need to input sale date that I input my self. The cell changes from example (12/1/2009) to 32453, but once you double click on the cell it show the hidden (12/1/2009) once you click out of it, it revets to the 32453 number. I check the cell format and it show as date. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date formated as date showing as number | Excel Discussion (Misc queries) | |||
How do I add 24 hours to a date and time value formated cell? | Excel Discussion (Misc queries) | |||
cell formated to 2 decimal places but excel shows it as 4 need 2 | Excel Worksheet Functions | |||
Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) |