Adding a digit

  • Thread starter Thread starter cj21
  • Start date Start date
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
 
Hi

Format>Cells>Number>Custom and enter 0000000000

Regards

Roger Govier
 
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!
 
Select column where are your codes, go to Cell->Number format, select
Custom, and define number format with ten digits : 0000000000
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a digit 4
Text vs. Number 5
Actual solution 2
Column Of Numbers To A Text Format Problem 1
2-digit - 6-digit 2
Making a number 8 digits long 3
Text Output To CSV 5
Number starting with zero 5

Back
Top