in said:
When I enter integers, excel puts in a decimal point before the last two
digits. How do I stop it doing this please. Thanks.
Hi,
The default is two decimal places, but that is easily changed.
Highlight the cells you wish to change the decimal places. (Click the
diamond at the intersection of the row and column headers if you want to
select all cells or use Edit > Select All).
From the Format menu choose Cells.
Click the Number tab
Under Category click Number
Where it says Decimal Places adjust the setting as desired.
Click the OK button
-Jim
--
Jim Gordon
Mac MVP
MVPs are not Microsoft Employees
MVP info
