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

Closed. This question 开发者_如何学JAVAdoes not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 7 years ago.

Improve this 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?

---

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