NumberFormat strings for Excel Cells

  • Thread starter Thread starter R. L. Alan Jordan
  • Start date Start date
R

R. L. Alan Jordan

Does anyone have a list of the format strings for the
various number formats for Excel cells. I am using OLE
to export a spreadsheet to Excel and need to also export
the cell formats. I know how to format for date,
currency, general, and fixed point numbers. I need to
know what the format string is for scientific notation.

Thanks in advance for your help.
 
Format a cell as Scientific. Then go back to Format/Cells/Number and select Custom in the
Category list. You'll see the existing format in the Type box.

In the box below that, you see all the built-in formats plus custom formats defined by the user.
To distinguish the two, if the Delete button is dimmed when you select one, it's built-in.

If you open a new workbook (and there are no custom formats defined by an add-in or by
Personal.xls), there shouldn't be any user-defined formats in the list.
 
Back
Top