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 = #04/29/2026 3:35:45 PM#
    
    '04/29/26
    MsgBox Format(myDate, "mm/dd/yy")
    
    'April 29 2026
    MsgBox Format(myDate, "mmmm d yyyy")
    
    'Wednesday
    MsgBox Format(myDate, "dddd")
    
    '04/29/2026 3:35 PM
    MsgBox Format(myDate, "mm/dd/yyyy h:nn AM/PM")
    
    'Wednesday 29 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: