Project

PSWriteOffice

PowerShell document automation across OfficeIMO's document, spreadsheet, presentation, PDF, Project, Access, EPUB, invoicing, and conversion engines.

View on GitHub Releases Get package
Stars 654
Forks 82
Open issues 1
Total downloads 4,320,051
Release OfficeIMO-v3.5.3
Language: C# Updated: 2026-11-03
Cmdlet

Get-OfficeExcelNumberFormatPreset

Aliases: ExcelNumberFormatPreset
Module
PSWriteOffice
Aliases
ExcelNumberFormatPreset
Inputs
None
Source
GetOfficeExcelNumberFormatPresetCommand.cs:17 Edit on GitHub

Lists OfficeIMO Excel number format presets and their format codes.

Syntax

Get-OfficeExcelNumberFormatPreset
[-CultureName <String>]
[-Decimals <Int32>]
[<CommonParameters>]
#
Parameter set: All Parameter Sets

Examples

Find a currency format for generated reports.

Get-OfficeExcelNumberFormatPreset -CultureName en-US -Decimals 2 |
                Where-Object Name -eq Currency

Returns the preset name and the Excel number format code that PSWriteOffice cmdlets can apply to cells or columns.

Parameters

-CultureName String optional
Culture name used for currency symbols, such as en-US or pl-PL.
-Decimals Int32 optional
Decimal places used for decimal, percent, currency, and scientific presets.

Common Parameters

This command supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable.

For more information, see about_CommonParameters.