Home |
Search |
Today's Posts |
#1
|
|||
|
|||
add leading "0"
How can I mass add a 0 to a field.
example: 544 = 0544 But I have about 2000 lines and I would like to mass add them. |
#2
|
|||
|
|||
Let's assume that the cells are in a column (say A):
1. insert a helper column near by 2. format the cells in the helper column as text 3. in the helper column insert ="0"&A1 4. copy this down 5. copy the helper column and paste it as value back into Column A. __________________________________________________ ___ You can avoid this if all your numbers are of fixed length, then use custom formatting: Format Cells Number Custom and enter as many zeros as you like -- Gary's Student "blt" wrote: How can I mass add a 0 to a field. example: 544 = 0544 But I have about 2000 lines and I would like to mass add them. |
#3
|
|||
|
|||
"blt" wrote: How can I mass add a 0 to a field. example: 544 = 0544 But I have about 2000 lines and I would like to mass add them. |
#4
|
|||
|
|||
Hi,
Try this as well. You will not need a helper column Select the cells and do a Ctrl+1 Now go to custom in the Number tab and click on General on the RHS Before general add the following (with the quotes) - "0" Regards, Ashish Mathur "blt" wrote: How can I mass add a 0 to a field. example: 544 = 0544 But I have about 2000 lines and I would like to mass add them. |
#5
|
|||
|
|||
Ashish:
Your solution is very good. It adds the leading zero to any size number and still leaves it a number suitable for calculations, -- Gary's Student "Ashish Mathur" wrote: Hi, Try this as well. You will not need a helper column Select the cells and do a Ctrl+1 Now go to custom in the Number tab and click on General on the RHS Before general add the following (with the quotes) - "0" Regards, Ashish Mathur "blt" wrote: How can I mass add a 0 to a field. example: 544 = 0544 But I have about 2000 lines and I would like to mass add them. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenation with leading zeros | Excel Worksheet Functions | |||
Leading zeros | Excel Discussion (Misc queries) | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) | |||
CSV leading zeroes | Excel Discussion (Misc queries) |