MS Query convert text to #

S

Shane

I am querying a data base that is returning a number as
text. Is there a way to convert the text to an actual
number in the query, before it is returned to excel???
Thanks to everyone that replies.
 
D

Debra Dalgleish

In Microsoft Query, you can create a calculated field. For example, if
the field name is ItemCode:

Click in a blank column heading
Type an expression to convert the text to a number, e.g.:
ItemCode+0
or
CLng(ItemCode)

Return the data to Excel
 
Top