Excel number format changes after upgradingto Service Pack 1 (SP1)

J

joaopedro

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

After installing SP1, Excel formated all percentage numbers with "." instead of "%".
Also, all numbers with decimal parts were multiplied by 100!
For example before SP1 install I had 4 cells with 12345 value but formated has follows:
12345
12.345,00
12.345,00€
1234500%
After SP1 install the same cells showed the following:
12345
1234.500,00
1234.500,00€
1234500.
It has something to do with how Excel interpets the comma and the point in number formating. The problem goes away when I change internacional format setting to USA the system preferences (I currently use International: Portugal format settings).
Can somebody help me to fix this?
Thanks!
JP
 
A

Antonio Correia

I have the exact same problem. Portuguese Location. It seems that some mac products are obviously USA orientated and this is one more bad example of this.
 
T

Tiago Fael

Well...just got the same problem...after reinstalling everything again...

There is however another fix...just move on to NeoOffice!

It's free and it works reasonably well...

Besides...Excel for Mac doesn't support VB Scripts either...
 

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

Similar Threads

Excel does not accept text format! 0
NUMBER FORMAT ERROR 3
excel changes numbers 1
Bug in Excel 2004 with Mac OS X 10.5 0
Formatting cells 2
Percentage format cell. how to changedisplaying 1,0. to 1,0% (take 2) 6
Excel Integers appear as decimal fractions 1
Currency symbol showing after the number 8

Top