LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Laurel
 
Posts: n/a
Default Can't change csv to xls

How can I change a .csv spreadhseet to a regular .xls spreadsheet? I've
tried SAVE AS, choosing .xls as the file type, but that doesn't work. When
I open the new .xls file, it's still in comma delimited format. If this
sounds strange, please see details below.

For years I've been downloading my credit card statement. The choice I pick
is "excel .csv". The file that gets downloaded has a .csv extension, but
when I open it, it is in standard .xls format. That is the items are in
cells, not enclosed in quotes, and not separated by commas. I'm not an
Excel user, typically, so I didn't think anything of it.

Today, however, two things changed.

1 - Instead of downloading to my PC, asking me where I wanted it saved, it
just opened up the spread sheet. I had to explicitly use the Excel SAVE AS
option to get it to store on my PC.

2 - The format was what I would think a csv file should look like, that is
items were enclosed in quotes and separated by commas.

I've inquired of the credit card company (e-mail -waiting for answer), as it
would seem that something had changed, but maybe not. Since I installed SP
2, who knows what it might be contributing to the situation.

TIA for any advice on any of these issues.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get the font color to change automatically depending on gtcarlsbad Excel Discussion (Misc queries) 2 February 1st 05 02:39 AM
How do I link two cells as to allow me to change the value in eit. jpvlvt Excel Discussion (Misc queries) 3 January 26th 05 01:28 AM
how do i make a date change automatically if i change one before . dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 09:21 PM
How to change the default font and size of "comments"? ClayMcQ Excel Discussion (Misc queries) 1 January 7th 05 11:43 PM
Worksheet Row Change event crazybass2 Excel Discussion (Misc queries) 4 December 8th 04 05:29 PM


All times are GMT +1. The time now is 08:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"