It is not that simple, check and you'll see that your number has changed, it
is not
6003860012345678

Excel has only 15 digits precision and will truncate numeric entries, you
need to format as text

--
Regards,

Peo Sjoblom


"Raymond" wrote in message
...
Awesome that works! Now what if there are already giftcard numbers in
there
and I am not typing it each time? Is there a way to do this. I tried to
highlight the whole column and choose that format but it did not work. It
allowed me to type new values in these cells which were then like
0006003860012345678. Thank you seriously for your help until now. How
crazy
it would have been that simple. Now I have all these spreadsheets with
the
numbers that I may need to type all over again.

"Patti" wrote:

Yes, but hilight the column or cells that you want formatted this way.

"Raymond" wrote:

Would I just go to Format Cells, Number Tab, Custom, and type 19 zeros
in
there?

"Patti" wrote:

Have you tried using a custom format on the cell with nineteen zeros?

"Raymond" wrote:

I have two one cell that I am using Cell A. I am typing giftcard
numbers in
the cells as 6003860012345678. The giftcard = 16 digits. I need
it to
default and place 3 zero's at the beginning of each of the giftcard
numbers
like "0006003860012345678". The giftcard should equal 19 digits
with the 34
zeros out in front. I tried merging them. Is there a way to do
this?

Sincerely,

Raymond