Formatting Numbers

[Zaf Khan]

Hi,

I want to show numeric values in a table cell, and I need to round it off to 2 decimal places.

I cannot use

= Format$(TheNumber,"00.00")

because vbscript doesn't support it.
Any ideas anyone?

DocZaf
{;->

VBScript supports the Round function.

?Round(TheNumber, 2)

[Zaf Khan]

Thanks Matthew and how about padding with zero's?


Zaf
{;->

What do you mean?

[Jeh]

lo there,

maybe I can help, you cant use the format function but you can use FormatNumber
ie for what you want try:

FormatNumber(TheNumber, 2)

then you shouldn't need to worry about the padding with 0's.

hope that helps

[Zaf Khan]

Thanks Jeh, that should do it,

thanks everyone.


DocZaf
{;->