View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sven Pran Sven Pran is offline
external usenet poster
 
Posts: 4
Default Cell formatting error, Excel 2003

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