• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Choosing the Right VBA Function > Using the Format Function

Using the Format Function

Formatting data can consume a lot of your time. Fortunately, the Format function provides a number of predefined formatting options. In addition, you can create user-defined formats for custom formatting needs. The possibilities are too numerous to adequately cover, but this section lists the tools you have at your disposal.

Caution

The most important thing to remember about the Format function is that the resulting value is a Variant String subtype—the resulting value’s data type does not remain the same. That means that although the Format function can make your data look good, you won’t want to use it with values used in other calculations. When a value needs manipulating before calculating, look to the conversion functions for help.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint