Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / August 2007



Tip: Looking for answers? Try searching our database.

Format of downloaded data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MikieSlats - 20 Aug 2007 09:42 GMT
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 - 20 Aug 2007 11:15 GMT
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

On 8/20/07 4:42 AM, in article
AEFAA224-5C13-42DF-8DC0-4743DE8B9095@microsoft.com, "MikieSlats"

> A data provider enables me to download real estate data that includes dollar
> amounts.
[quoted text clipped - 11 lines]
>
> Mikie
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.