You've lost me! It appears to work on my screen -- are you referring to the
actual data -- not just what is appearing on the screen?
"Peo Sjoblom" wrote:
Since Excel only has 15 digits of precision that won't work, only way is to
format as text or precede entries with an apostrophe '
one can then concatenate them
="000"&A1
where A1 holds the text formatted gift card number
--
Regards,
Peo Sjoblom
"Patti" wrote in message
...
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
|