formatting cells for radar graph

[Debbie Hurlbut]

Is there a way to format cells so that when you type in a
whole number, it is converted to a decimal?

(EX: If I type in 150, I want the cell to format this
whole number as .150)

I have a radar graph that I have set up to graph product
thickness, when the thickness is less than a whole number.
Thanks

 

[Bernard V Liengme]

Hi Debbie,
Yes: use Tools|Options and open Edit tab; locate Fixed Decimals and set it
to 3

However, I think this is "global" and will apply to all workbooks you
subsequently open; so do remember to set it off.

Alternative: enter the three digit numbers; type 1000 in an empty cell and
copy it; select you 3-digit data and use Edit|Paste Special-> divide; This
will give the rewired 0.150.

Best wishes
Bernard