![]() |
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. |
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. |
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 |
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