Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers in work sheet not Formating right
I have been wooking on this workbook for quite sometime. When I entered
number in a cell they entered just as I typed them 1 or 6.5 I saved and closed after entering several formulas everything was working propper...I opened my work and started working on it again However for some reason if I enter a number in a cell it now shows up as a decimal (1 is now 0.01) I now have to enter all numbers as 1.00 to show as 1 I have change the cell format to text and that has solved the problem However if I do that my formulas always return a vaule of 0 cells formated as General everything will work but 1 is 0.01 formated as number 1 is 0.01 I need to enter numbes with decimals so removing them is not an oppsion... any answers??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers in work sheet not Formating right
Uncheck this setting:
ToolsOptionsEdit tabFixed decimal places -- Biff Microsoft Excel MVP "OMGHelp" wrote in message ... I have been wooking on this workbook for quite sometime. When I entered number in a cell they entered just as I typed them 1 or 6.5 I saved and closed after entering several formulas everything was working propper...I opened my work and started working on it again However for some reason if I enter a number in a cell it now shows up as a decimal (1 is now 0.01) I now have to enter all numbers as 1.00 to show as 1 I have change the cell format to text and that has solved the problem However if I do that my formulas always return a vaule of 0 cells formated as General everything will work but 1 is 0.01 formated as number 1 is 0.01 I need to enter numbes with decimals so removing them is not an oppsion... any answers??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GETTING SELECTED DATA FROM A WORK SHEET TO OTHER WORK SHEET | Excel Discussion (Misc queries) | |||
HOW DO I CHECK FOR SIMILAR NUMBERS IN A WORK SHEET | Excel Worksheet Functions | |||
Conditional Formating won't work | Excel Worksheet Functions | |||
Populating work sheet combox with another work sheet values | Excel Discussion (Misc queries) | |||
how do Ii remove the grey page numbers in a work sheet | Excel Discussion (Misc queries) |