Rounding to a forced number of decimals

[Gijs van Swaaij]

Dear everyone,

I have a several numeric variables that need to be outputted as a
string (using the Cstr() function). However, I first want to round
those variables to a forced number of decimals (in most cases, 2
decimals). It works fine for most variables, except that something like
5.00 becomes just 5. Is there a way to let the string show those two
last decimals?

Thanks,
Gijs van Swaaij

 

[Baz]

Dear everyone,

I have a several numeric variables that need to be outputted as a
string (using the Cstr() function). However, I first want to round
those variables to a forced number of decimals (in most cases, 2
decimals). It works fine for most variables, except that something like
5.00 becomes just 5. Is there a way to let the string show those two
last decimals?

Thanks,
Gijs van Swaaij

Use the Format function instead of Cstr, e.g.

Format(some_number,"#,##0.00")

 

[Gijs van Swaaij]

Thanks a lot!