Removing decimal places 2

[JamesLynch]

After building an expression to work out a percentage value I am left with a figure like 4.22225645.

How can I cut the decimal places down to just one of two figures. Even Better can I round the value up and Down.

Thanks
James

 

[DonQuichote]

if it is for printing or showing on a report, use the Format$ function or set a textbox's format (look in the help for the keyword

Format

)

Best regards

 

[hwkranger]

use Cint() to convert to closest whole number;

Clng() if the || value is greater than 32,000 (absolute value)

or you can convert to currency, that'll automatically convert to 2 decimal places (i think)

if you don't like that.. you could always write your own function..









Cruz'n and Booz'n always.
This post shows what little I do at work.