Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to keep A=1.00 not changed to A=1# ?
Message
From
06/07/2006 04:39:57
 
 
To
05/07/2006 03:44:16
General information
Forum:
Visual Basic
Category:
VBA
Miscellaneous
Thread ID:
01133741
Message ID:
01134061
Views:
19
This message has been marked as the solution to the initial question of the thread.
I really don't understand the need to do it but If you want to achieve it for display purpose. You can have A assigned as 1.00 and then make use of Format functions. examples stated below:
' User-defined numeric formats.
msgbox formatnumber(a,3,0) 'Returns 1.000
msgbox formatcurrency(a,3,0) 'Returns $1.000 depending upon regional settings
Best Luck..
Nilesh
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform