Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My daughter called me this evening for help.
She typed 3.1 (decimal number) into a cell and it came out as "3,jan" which would have been correct had this been a date. But it is not. Of course I asked her to check the cell format, but whatever she changed the format to (on my instruction) it displayed the same! Decimal numbers that did not constitute a valid date (e.g. 3.16 or 35.2) came out as desired. (This is Norway with default date format DMY) Any suggestion where to start looking? regards Sven |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003: Error with date formatting | Excel Discussion (Misc queries) | |||
Excel 2003 cell formatting | Setting up and Configuration of Excel | |||
Strange 'protected cell' error affecting Excel 2003 but not Excel 2000? | Excel Discussion (Misc queries) | |||
Too Many Different Cell Format error in Excel 2003 | Excel Discussion (Misc queries) | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) |