Update Formatdata - PowerShell


Update-Formatdata updates the formatting data for a specified format provider. Formatting data defines how values are displayed and formatted when they are converted to strings. It allows for flexible customization of data output, making it easier to create visually appealing and informative reports and scripts.


Update-Formatdata [-FormatProvider] <string> [-Definition] <string> [-Disable] [-Force] [-PassThru] [-WhatIf] [-Confirm] [<CommonParameters>]


| Option | Description | Default Value |
| -FormatProvider | Specifies the format provider to update. Wildcards are accepted. | Required |
| -Definition | Specifies the new formatting definition to apply. | Required |
| -Disable | Disables the specified format provider. | False |
| -Force | Overwrites the existing formatting definition without confirmation. | False |
| -PassThru | Returns an object representing the updated format provider. | False |
| -WhatIf | Previews the changes that would be made without actually modifying anything. | False |
| -Confirm | Prompts for confirmation before executing the operation. | False |


Example 1: Updating the formatting definition for the number format provider

Update-Formatdata -FormatProvider 'number' -Definition '#,#.00'

Example 2: Disabling the xml format provider

Update-Formatdata -FormatProvider xml -Disable

Example 3: Previewing the changes before updating the string format provider

Update-Formatdata -FormatProvider 'string' -Definition 'MyCustomFormat' -WhatIf

Common Issues

  • Permission denied: Ensure you have sufficient permissions to update the specified formatting data.
  • Invalid format provider: Verify that the specified format provider is valid and exists.
  • Invalid formatting definition: Check the syntax of the formatting definition and ensure it’s in the correct format.


Update-Formatdata can be combined with other PowerShell commands to control the formatting of data displayed in reports or scripts. For example, it can be used with Export-Csv to customize the output of CSV files.

  • Get-Formatdata
  • New-Formatdata
  • Remove-Formatdata