format problem:

user needs to be able to enter numbers into a column and have trailing
zeros (if present) retained. [0.10, 0.100, and 0.1000 are different!]

..numberformat='@' works for this feature (text mode)

user also needs to be able to enter formula into cells in this column and
have them execute.

text format does NOT work for this feature, excel considers what is entered
as text and does NOT execute the formula.

..numberformat='general' will allow execution, but loses trailing zeros

How can I both retain trailing zeros and enter and execute formula into the
cells?

I guess I could
1) force format to text when a cell is selected
2) on change
check to see how many digits to the right of any decimal place
and create a format #.00... that has the same number of digits and
apply that to the cell.
if a formula is present[an = sign in first space], put it back and
hope that it will now be evaluated.

Is there an easier way to do this?


--
bz

please pardon my infinite ignorance, the set-of-things-I-do-not-know is an
infinite set.