Sidebar Sidebar
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Excel won't recognise .csv files properly :(

I

Ingredients

macrumors newbie
Original poster
Aug 17, 2010
8
0
Hey,
I have Excel 2008 on my Mac, and it won't open .csv files properly :(

If I save a spreadsheet as a .csv, it makes the separators semi-colons instead of commas. If I change the separators to commas in Text Editor and open it back up in Excel, it doesn't organise it in to cells but all stays in the A column again.

Any idea what I'm doing wrong or how to fix this?

Thanks very much, wrecking my head now at this stage!
 
You must log in or register to reply here.
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.
Top Bottom
Back