Guidelines to create a custom number format

1. Select the cell.

2. On the Home tab, in the Number group, select the small arrow to open the Dialog box or use shortcut key (Shortcut key: Ctrl + 1).

3.When the Format Cells appear, select Custom.

4. In the Type list, copy and paste the custom number format in the box. (For custom number format references, refer to page 3).

5. Select OK.

Custom Number Format Guidelines

1. Numeric Format

Formats (with decimals and thousands separator): 

#,##0.00;[Red](#,##0.00)

Sample Output: 

Formats (without decimals but with thousands separator): 

#,##0;[Red](#,##0)

Sample Output: 

2. Currency Format

Formats (without decimals but with thousands separator): 

RM#,##0;[Red](RM#,##0)

Sample Output:

Formats (with decimals and thousand separator): 

RM#,##0.00;[Red](RM#,##0.00)

Sample Output:

3. Accounting Format

Formats (with decimals and thousands separator): 

_-* #,##0.00_-;[Red](* #,##0.00)_-;_-* "-"??_-;_-@_-

Sample Output: 

Formats (without Decimals but with thousands separator): 

_-* #,##0_-;[Red](* #,##0)_-;_-* "-"_-;_-@_-

Sample Output:

4. Accounting Format with Currency

Formats (with decimals and thousands separator):

 _-RM* #,##0.00_-;[Red](RM* #,##0.00)_-;_-RM* "-"??_-;_-@_-

Sample Output:

Formats (without decimals but with thousands separator):

 _-RM* #,##0_-;[Red](RM* #,##0)_-;_-RM* "-"_-;_-@_-

Sample Output: