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

"Tricia LeAnn" wrote in message
...
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?
--
Have a fantastic day!

Tricia LeAnn