| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy cells with keeping exact formula intact | Excel Discussion (Misc queries) | |||
| Keeping cells in place | Excel Worksheet Functions | |||
| How do I fill down keeping one cell calculation from changing in . | Excel Discussion (Misc queries) | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
| How can I group a bunch of cells together, so I can sort by colum. | Excel Worksheet Functions | |||
Threaded Mode
