this might work better. the other one gives awrong answer if you have a whole
number.
put your number in A1.
=IF(ISERROR(SEARCH(".",A1,1)),A1,LEFT(A1,LEN(A1)-1)&"9")

"Nikki" wrote:

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?