Decimals?

[Tricia LeAnn]

How do I keep excel from taking away the decimals that I type in.

I typed 10.500, and it automatically changes to 10.5

How do I fix it?

 

[Chip Pearson]

You need to set the number format (Format menu, Cells item) to something
like #,##0.000



--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Gary''s Student]

It is easy if you have a fixed format.

Say we are typing in column A and we want always want 4 decimal digits:
1.2345

Format > Cells... > Number > Number and decimal places 4

 

[Tyro]

You have to custom format the cell to display the 0's, as in #0.000.or
#,0.000 if you want commas. It is not necessary to type 10.500. Just typing
10.5 will do if you format the cells. Unless you format the cells Excel does
not display leading 0's before the decimal point or trailing 0's after the
decimal point.

Tyro

 

[PCLIVE]

If all the numbers will have three decimal places, you could format the cell
as a number having 3 decimal places.
Right-click the cell or range of cells and select 'Format cells'. Select
'Number' and then adjust the decimal places as appropriate.

HTH,
Paul