Thanks Very much Kevin :)
"Kevin Lehrbass" wrote:
Hi Phil,
If you have your list of numbers (8 to 10 digits) in column A, put this
formula
=MID(A1,1,LEN(A1)-2) &C1 in column B (copy formula down to last
corresponding entry in Column A).
In Column C, insert the numbers that you want added.
The formula in column B will extract the numbers in column A (except the
last 2 numbers) and add the numbers that you have placed in column C.
You may want to copy column B and past special values only in another column.
If you have any questions let me know and have a great weekend!
--
Kevin Lehrbass
www.spreadsheetsolutions4u.com
"phil" wrote:
i need to know if i can change the last 2 digit's for an entire colum. it
currently has 8-10 digit's but i need to alter the last 2 for all rows. Is
this possible and how, if it is?
Thanks
Phil :)