Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
NumberFormat strings for Excel Cells
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
NumberFormat strings for Excel Cells
On Fri, 25 Jul 2003 14:44:17 -0700, "R. L. Alan Jordan"
wrote: I need to know what the format string is for scientific notation. 0.00E+00 --ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
NumberFormat strings for Excel Cells
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. On Fri, 25 Jul 2003 14:44:17 -0700, "R. L. Alan Jordan" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
NumberFormat | Excel Discussion (Misc queries) | |||
numberformat? | Excel Discussion (Misc queries) | |||
NumberFormat? | Excel Worksheet Functions | |||
using cells.numberformat | Excel Worksheet Functions |