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???

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???