Exporting an Excel file

[Gordon Biggar]

Before trying an Excel forum, I thought that I would state my question here
first, since it is Vista-related.

When I export a file from a website to an Excel spreadsheet where I am using
a Windows 2000 platform, it is saved as an Excel file. However, when I
export this same file from the same website on a Vista platform, it gets
saved as a CSV file. (I don't have the option of specifying the file format
at the website. The website does ask if one wants to save the file to
Excel.) I am using Office 2000.

What is the method for converting the CSV file to an Excel format?

Thanks in advance for any thoughts.

Gordon Biggar
Houston, Texas

 

[Chirag]

Excel can open a .csv file directly. Just double-click it and see. If it
does not get opened by Excel directly, right-click on the file and select
"Open With" | "Microsoft Excel" from the menu.

- Chirag

PowerShow - View multiple PowerPoint slide shows simultaneously
http://officeone.mvps.org/powershow/powershow.html

 

[Gordon Biggar]

I tried this. It opens the file into an Excel spreadsheet, but the numbers
are still displayed within quote marks, and the numbers are still separated
by commas.

GB

 

[DDW]

I tried this. It opens the file into an Excel spreadsheet, but the numbers
are still displayed within quote marks, and the numbers are still separated
by commas.

NOW do you think it's better to ask in an Excel group???

DDW

 

[+Bob+]

I tried this. It opens the file into an Excel spreadsheet, but the numbers
are still displayed within quote marks, and the numbers are still separated
by commas.

GB

When you open it, go through the text import wizard. Be sure to
specify the proper quote type as the text delimiter and the comma as
the field separator.

Back to your original question: How are you "exporting" from a web
site? Do you have a sample URL and rough instructions? Or is this
something being done on an internal corporate network?