Thread: Decimals?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Decimals?

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

"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