Hi,
I have a variation on this problem. I need to change every price ending in
"0" to one dollar lower. E.g. if it's $100, it needs to display $99. However,
all other prices can stay the same. Any suggestions?

Thanks!

"Corby" wrote:

Does Excel have the abilty to round to the nearest 9th?

Data Output
1.21 1.29
1.05 1.09
20.66 20.69