Problem when opening CSV files after update

T

TonyDS

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Hello

I have updated a Mac to OS 10.6
Before the update, when clicking on a CSV file (bank statements) the file would open in Microsoft Excel and display all the fields in their own columns.
Afer the update, all the fields are contained in one column. It looks like excel is not seeing the commas ? Previewing the CSV file in numbers works correctly though.
How can I resolve this?

Secondly, the CSV file has numbers (deposits) listed as +0000000023.99 for example. Before the update, that transaction would have showed as 23.99 in its column in excel - now it shows it as +0000000023.99.

Any assistance would be greatly appreciated.
 
B

Bob Greenblatt

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Hello

I have updated a Mac to OS 10.6
Before the update, when clicking on a CSV file (bank statements) the
file would open in Microsoft Excel and display all the fields in their
own columns.
Afer the update, all the fields are contained in one column. It looks
like excel is not seeing the commas ? Previewing the CSV file in numbers
works correctly though.
How can I resolve this?

Secondly, the CSV file has numbers (deposits) listed as +0000000023.99
for example. Before the update, that transaction would have showed as
23.99 in its column in excel - now it shows it as +0000000023.99.

Any assistance would be greatly appreciated.
Try using data-text to columns to parse the data. Some changes were made
in this area in the recent update to fix other problems. perhaps that is
causing your problem. The reason the number shows up that way is because
excel "thinks" the value is text. You can correct this in the text to
columns operation, or after by multiplying everything by 1.
 
X

XinXin

Hi Tony, in addition to what Bob suggested, can you please check whether your MacXL is updated to 12.2.4? We fixed a similar issue in 12.2.4.

Thanks,
XinXin Liu
Test Lead, Macintosh Business Unit, Microsoft
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top