Make the field Text instead of Numeric.
In a real number, the leading zeros are nonsensical. A stock number might be
000702, but one would never attempt to sum 000702 and 000001 to arrive at
000703. You would simply add 702 + 1 to get 703. There is no such thing as a
leading zero in a number, and trailing zeros make the number larger unless
they trail a decimal point, in which case they are dropped unless there is a
final interger that is not a zero. One would never say 000702.000. The
leading and trailing zeors would drop. One might say 702.001, in which case
all of the zeros would be retained.
The rule is that if the number is used in a calculation, there are no
leading zeros. If there are leading zeros, then the number is text and
cannot be used in a calculation unless it is converted, which strips out the
leading zeros.
If the number is a stock number, or any number that is not used as a
calculation, then it is Text.
"afdmello" <> wrote in message
news:...
>I have a number 000702 but in the cell only 702 appears. How do I format to
>see the preceeding zeros
>
> AFD
>
|
Similar Threads
Linear Mode
