Mister Epic
Mister Epic

Reputation: 16743

Excel saving CSV with tabs

I have a colleague using Excel 2007 on XP, and every time she saves her workbook as a .csv file, she is getting tabs for delimiters. Any idea what is happening, and how we can get commas instead?

Upvotes: 8

Views: 4702

Answers (2)

Mr.Monshaw
Mr.Monshaw

Reputation: 450

http://mavericksquest.blogspot.com/2011/06/excel-to-custom-character-delimited.html

if your default delimeter changed you can set it back there (in windows: Control Panel > Regional and Language Settings > Customize > Set List Separator field to ,) now you can save as csv through excel (saveas > other formats > csv)

Upvotes: 2

Patrick
Patrick

Reputation: 472

choose ms-dos csv as the file type!

Upvotes: 6

Related Questions