Get-OfficeExcelNumberFormatPreset

Aliases: ExcelNumberFormatPreset

Namespace PSWriteOffice

Aliases

ExcelNumberFormatPreset

Source

Sources/PSWriteOffice/Cmdlets/Excel/GetOfficeExcelNumberFormatPresetCommand.cs:17 Edit on GitHub

Lists OfficeIMO Excel number format presets and their format codes.

Remarks

Lists OfficeIMO Excel number format presets and their format codes.

Examples

Authored help example

Example 1: Find a currency format for generated reports.

PS>


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.

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.

Syntax

Get-OfficeExcelNumberFormatPreset [-CultureName <String>] [-Decimals <Int32>] [<CommonParameters>]

Parameter set: All Parameter Sets

Parameters

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