PredefinedNumberFormatId Property (Style)

Gets or sets the predefined number format with an Id. Built-in common formatting options exist, like in MS Excel. A specific Id can be set to format the content of a Cell, the Cells in a Column or the Cells in a Row with predefined formats. The default value is 0. Setting this property will overwrite the CustomFormat property.

Syntax

Visual Basic
C#

'Declaration
 
Public Property PredefinedNumberFormatId As Integer

'Usage
 
Dim instance As Style
Dim value As Integer
 
instance.PredefinedNumberFormatId = value
 
value = instance.PredefinedNumberFormatId

public int PredefinedNumberFormatId {get; set;}

Remarks

Here is the list of the predefined formats Id that can be set:

ID	FormatCode
0	General
1	0
2	0.00
3	#,##0
4	#,##0.00
9	0%
10	0.00%
11	0.00E+00
12	# ?/?
13	# ??/??
14	mm-dd-yy
15	d-mmm-yy
16	d-mmm
17	mmm-yy
18	h:mm AM/PM
19	h:mm: ss AM/ PM
20	h:mm
21	h:mm:ss
22	m/d/yy h:mm
37	#,##0 ;(#,##0)
38	#,##0 ;[Red](#,##0)
39	#,##0.00;(#,##0.00)
40	#,##0.00;[Red](#,##0.00)
45	mm:ss
46	[h]:mm:ss
47	mmss.0
48	##0.0E+0
49	@

Requirements

Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

Style Class
Style Members