Want to add to what Corby wrote.
I would like the same thig, but I would like Excel to round up or down.
Example:
1.21 becomes 1.19
1.35 becomes 1.39
1.34 becomes 1.29

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