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"
wrote in message
...

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