Can't Apply Number Format to Data Returned by SQL.REQUEST
Article ID: 131236
Article Last Modified on 8/15/2005
APPLIES TO
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0c
- Microsoft Excel 5.0a for Macintosh
This article was previously published under Q131236
This article also applies to:
- Microsoft Excel for Windows 5.0|5.0
-
Microsoft Excel for the Macintosh 5.0|5.0
SUMMARY
In Microsoft Excel 5.x or 7.0, if you use the XLODBC.XLA function
SQL.REQUEST to return data to your worksheet, you cannot apply a number
format to the data by choosing the Number command from the Format menu.
Using SQL.REQUEST creates a "link" to the data source and the data is
returned as text--therefore, the data cannot be reformatted using a number
format. This is by design in Microsoft Excel 5.x and 7.0.
Additional query words: 5.00a 5.00c XL
Keywords: kbprb KB131236