Joe Marks wrote:
How do I format a cell so that the number has a zero at the beginning of the
number?
I formated a cell. UnderOptions, at Leading zeros I selected 1 but that did
not work.
---------------------------------
Looking for a deal? Find great prices on flights and hotels with Yahoo!
FareChase.
From Help under leading zeros:
Here are various ways to enter integers starting with a zero:
o
Enter the number as text. The easiest way is to enter the
number starting with an apostrophe (for example, '0987). The
apostrophe will not appear in the cell, and the number will
be formatted as text. Because it is in text format, however,
you cannot calculate with this number.
o
Format a cell with a number format such as \0000. This
format can be assigned in the *Format code* field under the
*Format - Cells - Numbers* tab, and defines the cell display
as "always put a zero first and then the integer, having at
least three places, and filled with zeros at the left if
less than three digits".
The second choice doesn't really work the way it says but it will do
what you want.
Under Format for the cell you want to have a leading zero put "\00".
Then any number you enter will have a leading zero. (Based on my test
using 2.2 on Windows 2000)
When I put more than one zero after the backslash it zero-fills that
number of digits.
--
Thanks.
Yours,
**//Charlie
//***/Charles D. Seaman/**/
/* 770-617-1214
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
