Adding number to each cell in a column

M

mbradley222

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?
 
P

Paul B

mbradley222, one way, with Id numbers in column A in another column put
=10&A1, copy that column and paste special, valves, over the data in column
A

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"mbradley222" <[email protected]>
wrote in message
news:[email protected]...
 
Top