entering numbers

[roc2007]

When I enter integers, excel puts in a decimal point before the last two digits. How do I stop it doing this please. Thanks.

 

[Jim Gordon MVP]

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

 

[Mike Middleton]

roc2007 -

In Excel 2008, choose Excel | Preferences | Edit | uncheck Display this
number of decimal places.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[roc2007]

Thanks - that's great.