Thread: Decimals?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Decimals?

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)

"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