Format a field

[nsanto17]

I have a field that I am pulling from a data base that I need to always display the number as #.### with 3 Decimal Points.

Right now its being display as

1, 0, 2.5

I need it to display

1.000, 0.000, 2.500

Any idea on how i can make that work.

Thanks in advance.

 

[nsanto17]

I solved it.

I used FormatPercent(varPoints,3)

that worked...

Thanks

 

[vacunita]

That will depend on what you are using to pull the data from the DB.

You could even format it directly in the query so it gets retrieved in the format you want, but since you haven't specified the language or DB you are using, I'm afraid we can't be more specific than that.

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.