Thread: i need to add 01 to the end of 500 rows of numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default 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
Reply With QuoteReply With Quote