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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
The number is still 12345 NOT 1234501: the 01 is only formatting. Look at the
number in the formula bar.
 
Back
Top