Excel number format strings (e.g. "@", "$-409]d-mmm-yy;@") - Complete reference availability?

Question

I'm using Spreadsheet Gear to do some Excel programming. I want more control over number formats and it appears that I need to use the NumberFormat property to achieve this.

I've seen suggestions that you can use "@" to specify a string for example, but can't find a complete reference on this.

I'm guessing it's Excel specific as opposed to Spreadsheet Gear specific.

Can anyone help me to find a full reference, or at least a decent list?

Anybody knows if there is any option for the string section "@" of this format, for example, "@@@@-@@@@" for adding dashes, just like "0000-0000" as in Zip Codes? — Brethlosze, Feb 10 '16 at 20:38

Thomas · Accepted Answer · 2014-12-06T20:01:52.003

24

Here's a list of the Number Format Codes for Excel.

edited Dec 06 '14 at 20:01

answered Feb 24 '11 at 17:45

Thomas

63,911
12
95
141

Copy, paste, save! Thanks very much, I searched high and low for that. – gbro3n Feb 24 '11 at 18:16
link is down, just an FYI – James Ralston Dec 05 '14 at 16:57
They moved it. Fixed the link – Thomas Dec 06 '14 at 20:02
1

Second option for link: Ecma-376 4th Edition Part 1, Section 18.8.31 – Frison Alexander Apr 23 '15 at 14:36

Excel number format strings (e.g. "@", "$-409]d-mmm-yy;@") - Complete reference availability?

1 Answers1