View Single Post
  #1   Report Post  
Raymond
 
Posts: n/a
Default Merging Two Cells and Keeping the Values

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