Add a number infront of a number
I'd use the arithmetic technique (=a1+20000).
But if you decide to use the text version, you'll want to be careful if any of
your 4 digit numbers are less than a 1000:
="2"&text(a1,"0000")
or
=--"2"&text(a1,"0000")
The double minuses change the text back to numbers. (One changes it to a
negative number and the other changes it back to a positive number.)
Nikki wrote:
Hi,
I have a spreadsheet that has one column with a 4 digit number in each line.
I would like to copy the digits in this column to a new column and then add
a 2 infront of each 4 digits.
For example.
Column 1
8456
8764
7875
7864
Column 2
28456
28764
27875
27864
I have 500 lines so would like to know if there is a quick way of doing this.
Thanks
--
Dave Peterson
|