Thread: Adding number to each cell in a column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mbradley222 mbradley222 is offline
external usenet poster
  
Posts: 1
Default Adding number to each cell in a column

How can I add the number "10" to each existing number in a column. More
specifically, I have 450 cells in a column that contain different ID
numbers. I need to add "10" to the beginning of each of these numbers
and any future ID numbers in the column. Is there a simple function to
achieve this?


--
mbradley222
------------------------------------------------------------------------
mbradley222's Profile: http://www.excelforum.com/member.php...o&userid=37846
View this thread: http://www.excelforum.com/showthread...hreadid=574034

Reply With QuoteReply With Quote