Currency symbol issues with xlsx file format

[Blacksmith]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I've only had Office 2008 for Mac for a couple of weeks. I've used older files created with both Office 2003 (PC) and Office for Mac 2004 with no problems.

However, I created a new workbook this morning and saved it in the default xlsx file format. When I loaded it, all my currency columns had changed to 'Custom' format with the dollar currency symbol. So I changed it back to UK currency with the £ symbol and resaved.

When I loaded it, once again Excel has changed it to 'Custom' with the $ symbol (and yes, my International settings are correct in System Preferences).

As a work around, I can save the workbook in the Excel 97-2004 format.

Anyone else discovered this?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I've only had Office 2008 for Mac for a couple of weeks. I've used older files
created with both Office 2003 (PC) and Office for Mac 2004 with no problems.

However, I created a new workbook this morning and saved it in the default
xlsx file format. When I loaded it, all my currency columns had changed to
'Custom' format with the dollar currency symbol. So I changed it back to UK
currency with the £ symbol and resaved.

When I loaded it, once again Excel has changed it to 'Custom' with the $
symbol (and yes, my International settings are correct in System Preferences).

As a work around, I can save the workbook in the Excel 97-2004 format.

Anyone else discovered this?

Yes, this is a known problem. Hopefully a fix will be available shortly.
Keep watching Mactopia.

 

[CyberTaz]

I believe this is a bug which we "expect" to be fixed in the forthcoming
update - but as yet there is no availability time frame.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Blacksmith]

Thanks for these prompt replies.

At least I'm not alone but can't help but wonder why such an obvious bug wasn't picked up during testing.

 

[OAP Kiplin]

Yep, just found the error today on my intel MiniMac, not happy!

Kiplin

 

[CyberTaz]

Have you applied the 12.1 update? It reportedly contains the fix for that
bug. If not use Help> Check for Updates & see if the situation improves.

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 6/3/08 4:26 PM, in article
(e-mail address removed), "OAP Kiplin" <OAP