#1   Report Post  
Desmond
 
Posts: n/a
Default Sorry I am confused

I have downloaded a bank staTMENT IN csv format. I would like to save
AS .XLS When I save it (after re-sizeing the grids) it saves as an
xls.csv file not a strait foreward xls file and i am back to square
one. i have to re-size all the grids again.

Is there a way around this please.

  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Did you change the file type when saving?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Desmond" wrote in message
ups.com...
I have downloaded a bank staTMENT IN csv format. I would like to save
AS .XLS When I save it (after re-sizeing the grids) it saves as an
xls.csv file not a strait foreward xls file and i am back to square
one. i have to re-size all the grids again.

Is there a way around this please.



  #3   Report Post  
Desmond
 
Posts: n/a
Default

Yes I did to XXX.xls it changed it to XXX.xls.csv adding the CSV and
over wrighting my extension

  #4   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

No need to type the extension, choose save as microsoft excel workbook
(*xls)

--
Regards,

Peo Sjoblom


"Desmond" wrote in message
oups.com...
Yes I did to XXX.xls it changed it to XXX.xls.csv adding the CSV and
over wrighting my extension


  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default

Just to add to Peo's response:

In the File|SaveAs dialog, there's a dropdown box called:
"Save As Type:"
at the bottom.

Make sure you choose that "microsoft excel workbook (*.xls)" at the top of the
option list.

Peo Sjoblom wrote:

No need to type the extension, choose save as microsoft excel workbook
(*xls)

--
Regards,

Peo Sjoblom

"Desmond" wrote in message
oups.com...
Yes I did to XXX.xls it changed it to XXX.xls.csv adding the CSV and
over wrighting my extension


--

Dave Peterson


  #6   Report Post  
Jay
 
Posts: n/a
Default

Yes I did to XXX.xls it changed it to XXX.xls.csv adding the CSV
and over wrighting my extension


Sometimes when changing file type it's necessary to put quotes around the
file name in the "Save As" dialog box; for example,
"XXX.xls"
  #7   Report Post  
Ron Coderre
 
Posts: n/a
Default

Desmond: Please confirm that when you try to Save As, you are clicking the
"Save as type" drop-down list at the bottom of the window and selecting
"Microsoft Excel Workbook". The evidence implies that you may not be.

Regards,
Ron


"Desmond" wrote:

Yes I did to XXX.xls it changed it to XXX.xls.csv adding the CSV and
over wrighting my extension


  #8   Report Post  
Dave Peterson
 
Posts: n/a
Default

If you're saving it as a real excel file, then I've never had to add the double
quotes.

If I'm saving it as a (say) text file (normal extension is .txt) and I want to
call it xxx.xls (w/o the .txt), then I'd use the double quotes.

Jay wrote:

Yes I did to XXX.xls it changed it to XXX.xls.csv adding the CSV
and over wrighting my extension


Sometimes when changing file type it's necessary to put quotes around the
file name in the "Save As" dialog box; for example,
"XXX.xls"


--

Dave Peterson
Reply
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
check off, look up forms - VERY confused Abi Excel Discussion (Misc queries) 1 January 8th 05 01:47 AM
PV(), FV() confused by sign expected Karl Excel Worksheet Functions 1 December 27th 04 08:41 PM
create hyperlink in one cell with URL in a different cell confused on the tundra Excel Worksheet Functions 9 December 24th 04 03:22 PM
Frank, Sumproduct, it works but I am confused Danny J Excel Worksheet Functions 7 December 7th 04 07:32 AM


All times are GMT +1. The time now is 09:39 PM.

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

About Us

"It's about Microsoft Excel"