saving to csv file from excel 2007

[pourlance]

I need to save file to csv format to transfer to website...2003 always worked
fine - 2007 doesn't - help??

 

[Ron de Bruin]

Hi pourlance

Office Button >SaveAs

Or

Office Button >SaveAs (menu)
Other formats


Or use F12

Choose CVS in the list and save the file

 

[Gordon]

I need to save file to csv format to transfer to website...2003 always
worked
fine - 2007 doesn't - help??

What do you mean "2007 doesn't"? Doesn't what?

 

[pourlance]

When I save it as a csv file it doesn't hold the format it should for me to
transfer it - it shrinks the columns, changes the date column to #### due to
resizing it etc. I can't figure out what is different from 2003 version that
worked fine - does this make sense?

 

[Bernard Liengme]

Open the CSV file with Notepad to see what got saved

 

[pourlance]

I did that and the 2007 file has several commas after the information where
the 2003 file doesn't - that is the difference but I dont know how to correct
it in 2007

 

[Bernard Liengme]

Would you like to send me an AXLES file to experiment with?
My private email -- not the newsgroup
best wishes

 

[pourlance]

How do I do that? Would really appreciate the help - also have seen a
program for sale called "saving to csv" - would that work or is that a waste
of money?

 

[pourlance]

never mind i figured out and have sent them to you. thanks again

 

[Bernard Liengme]

File has not arrived (remove TRUENORTH from my email address)

 

[pourlance]

Did you ever receive this? I have sent it twice from my yahoo account

 

[Bernard Liengme]

No

 

[memocrono]

Excel 2003 CSV separate each of the value by the comma "," but Excel 2007 CSV separate by semicolon ";". I dont get it why MS change that.