Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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?

like image 249
gb2d Avatar asked Feb 24 '11 15:02

gb2d


People also ask

What number formats are available in Excel?

In Excel, you can format numbers in cells for things like currency, percentages, decimals, dates, phone numbers, or social security numbers. Select a cell or a cell range. On the Home tab, select Number from the drop-down.

How do I enable number format in Excel?

Select the cells that you want to format. On the Home tab, in the Number group, click the dialog box launcher next to Number (or just press CTRL+1). In the Category list, click the format that you want to use, and then adjust settings, if necessary.


1 Answers

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

like image 98
Thomas Avatar answered Sep 18 '22 13:09

Thomas