Format textboxes

06-01-2005, 06:12 PM
I want to be able to enter any number into a textbox in the following format 12.12 or 2.00 or -3.00

It has to show two digits after the decimal seperator and also allow negative numbers.

I also want to show the decimal seperator for the users regional settings.
Thank you

06-01-2005, 06:18 PM
Look up Format

06-02-2005, 12:28 AM
do you have any idea how do I know the decimal separator is "." or ","?

06-02-2005, 02:15 AM
Format$(somevalue, "#,##0.00") Will display at least the 3 digits (where the 0's are) and the period. Any leading zeros before the first one specified will be blanked out.

Format$(somevalue, "0,000.00") Will allways display all 6 digits wether there are leading zeros or not.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum