Decimals?

T

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

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)
 
G

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
 
P

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
 
Top