Thread: Decimals?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Decimals?

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

--
Gary''s Student - gsnu200767


"Tricia LeAnn" wrote:

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