I sent a spread to a co-worker that has some simple calculations. Some of the
calculations are average and standard deviation of value from the same
worksheet, which display properly. However, I am converting some values from
a different worksheet from millimeters to inches and the value displays as
the #NAME? error. Is there a default setting that he needs to change? Also, I
am using xl97 and he is using xl2000.