NUMBER FORMAT ERROR

[MVCarraretto]

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

When I format a cell containing the number 1.000 as a "Number with 2 decimal places and thousand separator (.) excel shows it as 100.000,00.
When I format a cell with the number 0,12 as "Percentage with 2 decimal places" excel shows it as "12,00." instead of "12,00%".
If I open a worksheet with these formats created by others, and I copy and paste the format to other cells it works well.
My international settings region is BRAZIL.

 

[Niek Otten]

Don't know, but maybe:
Tools>Options>Edit tab, UNcheck fixed decimal

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Version: 2008
| Operating System: Mac OS X 10.5 (Leopard)
| Processor: Intel
|
| When I format a cell containing the number 1.000 as a "Number with 2 decimal places and thousand separator (.) excel shows it as
100.000,00.
| When I format a cell with the number 0,12 as "Percentage with 2 decimal places" excel shows it as "12,00." instead of "12,00%".
| If I open a worksheet with these formats created by others, and I copy and paste the format to other cells it works well.
| My international settings region is BRAZIL.

 

[Niek Otten]

Sorry, Windows commands. Might be different on your Mac. Preferences?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Don't know, but maybe:
| Tools>Options>Edit tab, UNcheck fixed decimal
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|| Version: 2008
|| Operating System: Mac OS X 10.5 (Leopard)
|| Processor: Intel
||
|| When I format a cell containing the number 1.000 as a "Number with 2 decimal places and thousand separator (.) excel shows it
as
| 100.000,00.
|| When I format a cell with the number 0,12 as "Percentage with 2 decimal places" excel shows it as "12,00." instead of "12,00%".
|| If I open a worksheet with these formats created by others, and I copy and paste the format to other cells it works well.
|| My international settings region is BRAZIL.
|
|

 

[Phillip Jones]

In Excel2004 (may be same on 2008)

for Mac click column, row or cell(s) to Change.

Format menu > click on numbers > Click on percentage. chose desire
number of places 2,3,4

save changes.

Sorry, Windows commands. Might be different on your Mac. Preferences?

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>