Excel 2007 Date Keyboard Shortcut problem
even if the cell is formatted as general.
If the cell is 'number' formatted it stays a number.
--
Jim
"Daniel L. Lieberman" wrote in message
...
| Dave,
| That is the whole point the ctrl+; does not appear as anything other than
a
| formatted date regardless of the cell formatting. To be more specific it
| does not enter the date serial number even if the cell is formatted as
| general.
| Daniel
|
|