Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to keep A=1.00 not changed to A=1# ?
Message
De
06/07/2006 04:39:57
 
 
À
05/07/2006 03:44:16
Information générale
Forum:
Visual Basic
Catégorie:
VBA
Divers
Thread ID:
01133741
Message ID:
01134061
Vues:
20
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform