Adding a digit

C

cj21

I have a long list of product codes e.g. 230956743, 485048675. But i
want to put a zero in front of each one e.g. 0230956743, 0485048675. Is
there a quick way of doing this.

Obviously the column will have to be formatted as text because
otherwise the zero would dissapear.

Chris
 
D

Domenic

Assuming that Column A contains your data...

B1, copied down:

=0&A1

Then to convert these to values...

1) Select/highlight Column B

2) Format as 'Text'

3) Edit > Copy > Edit > Paste Special > Values > Ok

Hope this helps!
 
M

Mladen_Dj

Select column where are your codes, go to Cell->Number format, select
Custom, and define number format with ten digits : 0000000000
 
Top