Adding following Zero

[Dastard]

Hi Everyone , have a nice day

assume i m working in excel cells and i have this number
120
i drag it downwards till 20 cells and then click insert series
i get something like
120
121
122
...
140

now how can i add a following zero to this series to make it like
0120
0121
0122
...
0140


Regards and waiting ..

[Bryan Hessey]

Hi Everyone , have a nice day

assume i m working in excel cells and i have this number
120
i drag it downwards till 20 cells and then click insert series
i get something like
120
121
122
...
140

now how can i add a following zero to this series to make it like
0120
0121
0122
...
0140


Regards and waiting ..

Hi,
select the range (column) of cells, and Rightmouse, Format Cells, (Number tab) Custom and set 0000

hth
---