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. |
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 |
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. |
All times are GMT +1. The time now is 04:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com