| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In spread sheet the numbers entered as whole numbers become decim
I have been working with a spread sheet where each cell is a whole number. I
tried to enter numbers today and while I enter a whole number it reverts to a decimal. ie: 5 becomes .05. It has always been formatted as simly a general number. I've tried to set up a new work sheet but same thing happens -- George |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In spread sheet the numbers entered as whole numbers become decim
Hi George,
Goto ToolsOptionsEdit Tab and uncheck 'fixed decimal places' HTH Martin |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In spread sheet the numbers entered as whole numbers become decim
Uncheck this setting:
ToolsOptionsEdit tabFixed decimal places Biff "George A. Yorks" .(donotspam) wrote in message ... I have been working with a spread sheet where each cell is a whole number. I tried to enter numbers today and while I enter a whole number it reverts to a decimal. ie: 5 becomes .05. It has always been formatted as simly a general number. I've tried to set up a new work sheet but same thing happens -- George |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In spread sheet the numbers entered as whole numbers become de
Thanks for the information. If possible, what caused the 'fixed decimal
places' to be suddenly checked. -- George "MartinW" wrote: Hi George, Goto ToolsOptionsEdit Tab and uncheck 'fixed decimal places' HTH Martin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spread sheet calculating/not calc from opening file differently | Excel Worksheet Functions | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| HOW TO PREVENT NUMBERS IN SPREAD SHEET FROM ROUNDING | New Users to Excel | |||
| Excel window in spread sheet? | Excel Discussion (Misc queries) | |||
| micosoft excel dates entered but changed to sequencial numbers ho. | Excel Worksheet Functions | |||
Linear Mode
