i need to add 01 to the end of 500 rows of numbers
 

i have 500 numbers in rows, i need to add 01 to the end of all the numbers is
there anyway easy of doing this

i need to add 01 to the end of 500 rows of numbers
 

Multiply the numbers by 100 and then add 1.

--
HTH...

Jim Thomlinson


"sammies3" wrote:

i have 500 numbers in rows, i need to add 01 to the end of all the numbers is
there anyway easy of doing this

i need to add 01 to the end of 500 rows of numbers
 

Many Thanks

I have just found another way too
go to format cells then custom, type ##### for the amount of digit in the
cell followed by "0"1
so it reads #####"0"1
12345 turns to 1234501

"Jim Thomlinson" wrote:

Multiply the numbers by 100 and then add 1.

--
HTH...

Jim Thomlinson


"sammies3" wrote:

i have 500 numbers in rows, i need to add 01 to the end of all the numbers is
there anyway easy of doing this

i need to add 01 to the end of 500 rows of numbers
 

OK if the numbers are integers.
--
David Biddulph

"Jim Thomlinson" wrote in message
...
Multiply the numbers by 100 and then add 1.

--
HTH...

Jim Thomlinson


"sammies3" wrote:

i have 500 numbers in rows, i need to add 01 to the end of all the
numbers is
there anyway easy of doing this

i need to add 01 to the end of 500 rows of numbers
 

The number is still 12345 NOT 1234501: the 01 is only formatting. Look at the
number in the formula bar.

"sammies3" wrote:

Many Thanks

I have just found another way too
go to format cells then custom, type ##### for the amount of digit in the
cell followed by "0"1
so it reads #####"0"1
12345 turns to 1234501

"Jim Thomlinson" wrote:

Multiply the numbers by 100 and then add 1.

--
HTH...

Jim Thomlinson


"sammies3" wrote:

i have 500 numbers in rows, i need to add 01 to the end of all the numbers is
there anyway easy of doing this