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

31.1k Views Asked by At

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?

1

There are 1 best solutions below

4
On BEST ANSWER

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