S
sammies3
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
there anyway easy of doing this
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim Thomlinson
Multiply the numbers by 100 and then add 1.
S
sammies3
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
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
D
David Biddulph
OK if the numbers are integers.
T
Toppers
The number is still 12345 NOT 1234501: the 01 is only formatting. Look at the
number in the formula bar.
number in the formula bar.