Format of downloaded data

[MikieSlats]

A data provider enables me to download real estate data that includes dollar
amounts.

The search through Internet explorer shows a page of data which can then be
downloaded to Excel. However the dollar items come into Excel as labels
rather than numbers which then prevents me from manipulating this data.

This only happens when I download the data with my office desktop computer.
When I download it at home or on my laptop the data comes through as numbers
not labels. This suggests that I have a setting which is incorrect on my
office desktop.

Does anybody have any thoughts?

Mikie

 

[CyberTaz]

Since you make no mention of it I'm guessing, but I'd say you're using
Windows-based systems - this group is Excel for Mac Not that you aren't
welcome here, but it sounds like a browser issue & IE for Mac is defunct.

It could have to do with browser version - are you possibly using a newer
version of IE on the LT? If the versions are the same there may be a setting
involved but I can't help you there. Doubt that it's an Excel issue though,
but it will help to indicate whether the file is downloaded as an Excel
file, a text file, etc. or whether it's coming into an Excel worksheet as
the direct result of a web query.

One suggestion as a workaround - If by "labels" you you mean that the
figures *are* going into cells but being treated as text - type the number 1
into an empty cell, copy it, then select the cells with the wayward content
& use Edit> Paste Special> Multiply to convert the text numbers to values.
You'll probably lose the currency formatting but that's easy reapplied.

For more start at the link below to find the right Windows group:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

HTH |:>)
Bob Jones
[MVP] Office:Mac