see if this help:
=LEFT(A1,LEN(A1)-1)&"9"
nikki

"Mulina" wrote:

After performing a series of calculations on a column of numbers in excel
(2002), I need to change the last digit in each answer to 9. Is there a
function or formula that will help me do this?