PUTTING NUMBERS IN A CELL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I AM TRYING TO ENTER A NUMBER THAT BEGINS WITH ZERO'S AFTER I ENTER IT THE ZERO'S DISAPPEAR, HOW DO I KEEP THEM IN
 
Please turn off the CAPS Lock, more than two lines would
be extremely difficult to read. Reading caps is annoying.

Format the column as text, if the leading zero is important to
you then it is an identification not a number. The default
alignment for text is left aligned which is also better for
most identification "numbers".

Credit card numbers are 16 digits, are identification and
can not be entered as numbers, ever, because Excel only
retains 15 significant digits.

Identification "numbers" are seldom used arithmetically,
except perhaps to create check digits, but that can usually
be done with strings anyway.
 
-----Original Message-----
I AM TRYING TO ENTER A NUMBER THAT BEGINS WITH ZERO'S
Click to expand...
AFTER I ENTER IT THE ZERO'S DISAPPEAR, HOW DO I KEEP THEM
IN
.
place the the symbol ' (same key with the quotation "
Click to expand...
make)and then enter your number
 
-----Original Message-----
I AM TRYING TO ENTER A NUMBER THAT BEGINS WITH ZERO'S
Click to expand...
AFTER I ENTER IT THE ZERO'S DISAPPEAR, HOW DO I KEEP THEM IN
.
Click to expand...

Go to Format --> Number --> Custom --> then type in box the
number of zeros you want before the number.

For example, if you choose to type 0000000 in the box under
custom, your number of lets say 234 will appear as 0000234
in the cell.
 
You can pre-format the cell for TEXT, or put a leading apostrophe (') on
your number........(the apostrophe will make it TEXT and not show up)

Vaya con Dios,
Chuck, CABGx3
 
Back
Top