Thank you for the quick answered. It was exactly what I needed.
"Gary''s Student" wrote:
Pull-down
Tools Options Edit and clear the fixed decimal checkbox.
--
Gary''s Student
"Tim Poulter" wrote:
I am trying to format numbers as a four digit number. If I format the cell
with
numbers, no decimal places, no separator, the last two numbers don't show.
(Instead of 1124 I get 11)
If I format it as general, it come up with two decimal places. (Instead of
1124 I get
11.24).
|