VBA Function: Format

The VBA Format function returns a string based on a date or number in the specified format.

Usage:

Format(value, format)

Examples of Usage

Using the Format function to return the following values in different formats:

Sub example()

    '98.1%
    MsgBox Format(0.9814, "0.0%")

    '54,321.90
    MsgBox Format(54321.9, "##,##0.00")

    '$54,321.90
    MsgBox Format(54321.9, "$#,##0.00")

End Sub

Using the Format function to return the following date in different formats:

Sub example()
    
    myDate = #05/04/2024 3:35:45 PM#
    
    '05/04/24
    MsgBox Format(myDate, "mm/dd/yy")
    
    'May 4 2024
    MsgBox Format(myDate, "mmmm d yyyy")
    
    'Saturday
    MsgBox Format(myDate, "dddd")
    
    '05/04/2024 3:35 PM
    MsgBox Format(myDate, "mm/dd/yyyy h:nn AM/PM")
    
    'Saturday 4 at 3:35 PM
    MsgBox Format(myDate, "dddd d at h:nn AM/PM")

End Sub

Date Formats

Table of different date formats usable with the Format function: