Exporting numbers with .IQY file

Tags:
.IQY file
Microsoft Excel
When I open an .IQY file, my numbers become a text, e.g. '=5.3. I can manually change them but will go back to a text when I refresh. How can this be corrected?


Software/Hardware used:
iqy
1

Answer Wiki

Thanks. We'll let you know when a new response is added.
From what I see an IQY file contains a URL and other parameters for making a query over the Internet; allows information to be retrieved from an .ASP Web page and imported into Microsoft Excel; saved in the \Program Files\Microsoft Office\Queries directory by default.

in your example 5.3. is not a valid number. You cannot have multiple decimals in a numeric value. It looks like it may be part of an IP address.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: