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

Hello <br><br>I have updated a Mac to OS 10.6 <br>
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. <br>
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. <br>
How can I resolve this? <br><br>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. <br><br>Any assistance would be greatly appreciated.

On 3/24/10 8:12 AM, TonyDS@officeformac.com wrote:
> 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.

-- 

Bobgreenblattatmsndotcom

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. <br><br>Thanks,  <br>
XinXin Liu  <br>
Test Lead, Macintosh Business Unit, Microsoft <br><br>> On 3/24/10 8:12 AM, TonyDS@officeformac.com wrote: <br>
> > Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Hello <br>
> > <br>
> > I have updated a Mac to OS 10.6 <br>
> > Before the update, when clicking on a CSV file (bank statements) the <br>
> > file would open in Microsoft Excel and display all the fields in their <br>
> > own columns. <br>
> > Afer the update, all the fields are contained in one column. It looks <br>
> > like excel is not seeing the commas ? Previewing the CSV file in numbers <br>
> > works correctly though. <br>
> > How can I resolve this? <br>
> > <br>
> > Secondly, the CSV file has numbers (deposits) listed as +0000000023.99 <br>
> > for example. Before the update, that transaction would have showed as <br>
> > 23.99 in its column in excel - now it shows it as +0000000023.99. <br>
> > <br>
> > Any assistance would be greatly appreciated. <br>
> Try using data-text to columns to parse the data. Some changes were made  <br>
> in this area in the recent update to fix other problems. perhaps that is  <br>
> causing your problem. The reason the number shows up that way is because  <br>
> excel &quot;thinks&quot; the value is text. You can correct this in the text to  <br>
> columns operation, or after by multiplying everything by 1. <br>
>  <br>
> --  <br>
>  <br>
> Bobgreenblattatmsndotcom <br>
>