vnd.ms-excel.numberformat:@

I use a cloud-computing app, Salesforce, to maintain some databases. The report module, which produces nice-looking formatted reports, allows you to export the data as .csv files, which can be opened without trouble by Numbers. It also allows you to export them (formatting intact) as .xls files, which are (according to their first line) in this vnd.ms-excel.numberformat. I recently downloaded a trial of Microsoft Office, and those files were opened without trouble by excel (formatting intact).

Is there any way to open them in Numbers so that the formatting remains? Here is a sample lines: it's obviously html code but I can't get Numbers to read it as that.
"<tr><td style=""vnd.ms-excel.numberformat:@"">xx Durst Membership Donation - 03/05/2010</td><td align=right>5.00</td><td align=right>3/5/2010</td><td style=""vnd.ms-excel.numberformat:@"">xx Durst Household</td><td style=""vnd.ms-excel.numberformat:@"">Membership 2010</td></tr>"

macbook pro, Mac OS X (10.6.7), vmfusion, iWorks, Chrome

Posted on Mar 29, 2011 12:51 PM

Reply
4 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

vnd.ms-excel.numberformat:@

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.