Application.Formats

This property returns a collection of spreadsheet formats.

This property is read only.

Syntax Parameters Return Value
- - Formats

SVB Example

Changing the global spreadsheet number format: 

Option Base 1
Option Explicit
Sub Main
    'change the "Normal" format to a currency number format
    Application.Formats(2).NumberFormat = "$0.00"
End Sub