How to add 2 digits to the end of a four digit number

**Gordond54** · 12-31-2012, 05:30 PM

I have a large list of 4 digit numbers that i need to add 01 to all. How can i do this quickly instrad of manually.

thanks
gordon

**Melvinrobb** · 12-31-2012, 05:34 PM

if your number is in A1, put the following formula in B1:
=A1&"01"

**Melvinrobb** · 12-31-2012, 05:35 PM

Another way would be:
=(a1*100)+1

**Armando Montes** · 12-31-2012, 07:32 PM

Might try custom format:
?"01"

**Kevin UK** · 01-01-2013, 07:06 AM

Hi Gordond54

To add to Melvinrobb's post #2: =(A1&"01")+0. Turns it into a real number the same as post #3.

**martindwilson** · 01-01-2013, 09:15 AM

you could probably achieve the same thing by putting 100 in a spare cell then copy paste special multiply
then change to 1 copy paste special add

**jqq** · 01-01-2013, 04:19 PM

Originally Posted by Melvinrobb

if your number is in A1, put the following formula in B1:
=A1&"01"

Best option here

Re: How to add 2 digits to the end of a four digit number