None 
Exporting an Excel file 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
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
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
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
“Originally Posted by BiggarBefore 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
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
are still displayed within quote marks, and the numbers are still separated
by commas.
GB
“Originally Posted by ChiragExcel 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" <
On Thu, 26 Mar 2009 02:28:26 -0500, "Gordon Biggar"
<
NOW do you think it's better to ask in an Excel group???
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.
DDW
On Thu, 26 Mar 2009 02:28:26 -0500, "Gordon Biggar"
<
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?
<
“ 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
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?
vBulletin, Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.3.1 © 2009, Crawlability, Inc.
LinkBacks Enabled by vBSEO 3.3.1 © 2009, Crawlability, Inc.
©2009 TechAsk.com, All Rights Reserved.
