hi all

i require a bit of help in rounding some figures in an excel spreadsheet. my figures are listed and are as follows

1.87 want this to change to 1.89
3.08 want this to change to 3.09
3.06 want this to change to 3.09
4.38 want this to change to 4.39
3.82 want this to change to 3.85
0.92 want this to change to .95
6.52 want this to change to 6.55
6.49 want this to change to 6.49
1.82 want this to change to 1.85

unfortunatley if there were only these numbers i would do it manually but there are over 10000 code and prices. so to reiterate. only want the end numbers to be either 0, 5 or 9. If number ends in 0, 5 or 9 it should stay at those numbers. so 1 - 4 change to end in 5, 6 - 8 change to end in 9

is there a wizz out there that cna help?

Chris