| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total numbers which are the same to be displayed | Excel Discussion (Misc queries) | |||
| The way numbers are displayed | New Users to Excel | |||
| Wrong number displayed. | Excel Discussion (Misc queries) | |||
| Value displayed on graph is wrong- but graph is right? | Charts and Charting in Excel | |||
| formatted numbers displayed as ##### | New Users to Excel | |||
Linear Mode
