ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   numbers displayed wrong (https://www.excelbanter.com/excel-discussion-misc-queries/236924-numbers-displayed-wrong.html)

Richard van Rijsbergen

numbers displayed wrong
 
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.

Bob Phillips[_3_]

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.




NBVC[_98_]

numbers displayed wrong
 

Go to Tools|Options and in the Edit tab, uncheck the Fixed Decimal
option.


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116174


Richard van Rijsbergen[_2_]

numbers displayed wrong
 
It works. Thnx

"Bob Phillips" wrote:

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.






All times are GMT +1. The time now is 05:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com