• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 403
  • Last Modified:

User-Defined Numeric Formats

Hi:
     Can someone give me information plus examples on how to use User-Defined Numeric
Format functions in Visual Basic 6?
0
LearningJava
Asked:
LearningJava
2 Solutions
 
GrahamSkanRetiredCommented:
0 stands for a digit
# stands for a digit, except for leading or trailing zeros
. is the decimal placeholder, regardless of region
, separates the thousands, regardless of region

The actual printed decimal and thousands separators ARE regional.

other characters are printed as is.

Format(8315.4, "00000.00") gives  08315.40
Format(8315.4, "#####.##")         8315.4
Format(8315.4, "##,##0.00")        8,315.40
Format(315.4,"$##0.00") $315.40  
0
 
ShauliCommented:
...and:

MsgBox FormatNumber(x, 2)   'will format number with the required decimals after the decimal sign = 1,255,666.25
MsgBox FormatPercent(x, 2)    'will format a number as a percent (times 100 and % sign)  = %59.25
MsgBox FormatCurrency(x, 2)   'will format number as a currency  =  $1,255,666.25


S
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now