truncating and rounding

[Chang]

Hello,

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

Many thanks
Chang

 

[Tom Ogilvy]

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


if you mean in a cell

Format=>Cells=>Number Tab

select number and set decimals to 2.