how do I get excel to change the last digit in a cell

M

Mulina

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

Nikki

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")
 
D

Dave Peterson

If they are whole numbers:

=int(a1/10)*10+9
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?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Truncating Number Series 3
Compare last digit in 5 cells for match 0
Excel does not accept text format! 0
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Excel - Wich Function should I use? 1
How add a digit to front of number in each cell in excexl column 1
Excel Changes My Last Digit to Zero 1
Covert 9 digits to 10 in excel 2

Top