NumberFormat strings for Excel Cells

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.
 
M

Myrna Larson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top