"Gaurav" wrote:

Sorry...missed a step.

Select the entire rangeright clickFormat Cellsselect 'Number' in the
listset to 2 decimal places.


In the formula bar it still shows 1.00999999999999 etc.... Formating only
effects the value in the cell.