Skip to main content
SearchCtrl K
Community

Source code

OfficeIMO.NET libraries, PowerShell module, CLI, Studio and browser tools 609 stars

Talk and help

DiscordQuestions, ideas and show and tell Report an issueBugs and feature requests SponsorFund ongoing development

Mode

Background

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Search the whole siteOpen search page →
Documentation Search all OfficeIMO/
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

Authored help example

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.