How to keep the insignificant zero's

[Joe]

am trying to capture the number of decimal digits in a
cell. When the cell has all zeros(say 4) after the
decimal, the cell shows zero decimal digits instead of 4.

eg:

484.0000 decimal digits shown are 0 instead of 4 but if i
have 484.4432 it shows 4 decimal digits. So the problem
revolves around the zeros after the decimal.

Does anyone has a solution for this problem, please let me
know. Thanks in advance.

formatting to 0.00 will work, but I may want to format to
0, 0.0, 0.00. 0.000 or 0.0000 depending on certain
criteria. I want to avoid having to reformat the colum
each time, preferring to have the user input the number of
decimal places needed each time while maintaining trailing
zeroes. Any thoughts? Thanks for your input.


..

 

[Earl Kiosterud]

Joe,

One way is to format the cell in advance as text. Some mathemetical
functions won't work on such data, but can be coerced into working.