Hello,

When truncating and rounding figures, how do I get excel
to display any significant 0's in the final result

Many thanks
Chang

format(application.Round(vVal,2),"#.00")


if you mean in a cell

Format=Cells=Number Tab

select number and set decimals to 2.

--
Regards,
Tom Ogilvy

"Chang" wrote in message
...
Hello,

When truncating and rounding figures, how do I get excel
to display any significant 0's in the final result

Many thanks
Chang