Does putting this formula in B1 and copying down give you what you want?

=10*INT(A1/10)

Change the A1 to A2 and put the formula in B2 if you have a header row.

--
Rick (MVP - Excel)


"BLR" wrote in message ...
In column A I have a list of nuimbers. I ran a conditional format to
highlight certain ranges of percentiles (above 80% and above 90%). Is there
a way to get column B to acutally display what the percentile is?