Format Builder

The VB6/VBA Format function allows you to customize the way values are displayed and printed. Unfortunately, it's difficult to remember all the arguments and syntax for this function. The Format Builder makes it simple to format expressions for numbers, currency, date/time, and strings. Use the formats we've provided or add your own. Select the options from the list and see how it is applied to your sample data. No more trial and error in the Immediate Window!

Details...