Hi
A better alternative than my first posting would be to format the cell.
FormatCellsNumberCustom and in the white pane type #,##.00 "HOURS"
You will then see 39.61 HOURS but the numeric value will still be
39.6099999999997
Regards
Roger Govier
Cricketer wrote:
I agree with Roger except I think you need a /100 in the calculation.
Even if you put in 0.00000000% you still retain the integrity of the
calculation.
I tried several options including Concatenate and all but this method lose
the accuracy of the calculation. Anyone know why?
|