truncating and rounding

  • Thread starter Thread starter Chang
  • Start date Start date
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
 
format(application.Round(vVal,2),"#.00")


if you mean in a cell

Format=>Cells=>Number Tab

select number and set decimals to 2.
 
Back
Top