Thread: numbers displayed wrong
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
  
Posts: 2,420
Default numbers displayed wrong
Goto ToolsOptionsEdit and uncheck Fixed Decimal Places

--
__________________________________
HTH

Bob

"Richard van Rijsbergen" <Richard van
wrote in message ...
When i type for example 22 in my excel sheet it is displayed as 0,22
This is also when i open a new empty sheet/workbook.


Reply With QuoteReply With Quote