Can't Apply Number Format to Data Returned by SQL.REQUEST (131236)


The information in this article applies to:

  • Microsoft Excel for Windows 95
  • Microsoft Excel for Windows 5.0c
  • Microsoft Excel for the Macintosh 5.0a
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.

MORE INFORMATION

To work around this limitation, you may use the TEXT function to reformat the data. For example, the following formula returns the text "6/5/1987":

=SQL.REQUEST("DSN=NWind",,,"SELECT Hire_Date FROM Employee WHERE Last_Name = 'Davolio'")

This formula can be modified so that the date is displayed in a different Date format. For example, the following formula returns the text "Jun-05- 1987":

=TEXT(SQL.REQUEST("DSN=NWind",,,"SELECT Hire_Date FROM Employee WHERE
Last_Name = 'Davolio'"),"mmm-dd-yyyy")

Modification Type:MinorLast Reviewed:8/15/2005
Keywords:kbprb KB131236
©2004 Microsoft Corporation. All rights reserved.