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

excel number-formatting spreadsheetgear
gb2d picture gb2d · Feb 24, 2011 · Viewed 29.4k times · Source

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?

Answer

Thomas picture Thomas · Feb 24, 2011

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

Related questions

Excel CSV - Number cell format

I produce a report as an CSV file. When I try to open the file in Excel, it makes an assumption about the data type based on the contents of the cell, and reformats it accordingly. For example, if the …

Read More
Formula to convert date to number

I would like to know the formula to convert a date in 10/26/2013 to 41573 number as done in Excel. Like how 10/26/2013 is converted to 41573.

Read More
Excel Number Format: What is "[$-409]"?

i'm automating excel, using the macro system as a guide to what i should do through automation. When i format a column as a date, the macro generated a NumberFormat for the column to be: [$-409]m/d/yy h:…

Read More