truncating and rounding

C

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
 
T

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.
 
Top