Thousands Separator

Question

Level 1

4 points

Thousands Separator

The thousand separator in Pages and Numbers does not work. I have selected the cells and then checked the thousands separator box and it still doesn't work. Any help would be appreciated.

imac, Mac OS X (10.5.4)

Posted on Feb 3, 2009 7:25 AM

Reply

Answer 1

Feb 3, 2009 6:46 PM in response to zakyak

Yes, Zak, it does work.

Perhaps you could post an example of what happens when you try.

Jerry

Reply

Answer 2

zakyak Author

Level 1

4 points

Feb 3, 2009 8:11 PM in response to Jerrold Green1

If I put in 123456 I get 123456. No comma. nothing. But wait I did contact phone support and here is what he said. Honest this is the truth. He tried IWork 8 on his computer and agreed it didn't work but it did work with v. 9. Then he says he used Excel in college and Excel does not use commas! All I know is that when I follow the directions the thousand separator does not work.

zak

Reply

Answer 3

Feb 4, 2009 6:22 AM in response to zakyak

zak,

With the content cell Selected, when you look at the Cells Inspector, does the Inspector Pane look just like my Numbers 08 example? What differences are there, if any?

Jerry

Reply

Answer 4

KOENIG Yvan

Level 8

41,819 points

Feb 5, 2009 11:36 AM in response to Jerrold Green1

Hi Jerrold

Numbers, is really foolish. 😉
I apply 'thousand separators' and get no comma 🙂

Yvan KOENIG (from FRANCE jeudi 5 février 2009 20:36:19)

Reply

Answer 5

Feb 5, 2009 11:44 AM in response to KOENIG Yvan

Is that a Language issue?

Jerry

Reply

Answer 6

KOENIG Yvan

Level 8

41,819 points

Feb 5, 2009 12:02 PM in response to Jerrold Green1

Sure.

French of France (& Canada) uses a space (can't use comma which is our decimal separator) 123 456,78
French of Belgium (& Luxembourg) uses period. 123.456,78

French of Swiss uses the period as decimal separator and the single quote as thousand separator. 123'456.78

Which is the height of the Babel Tower ?

Yvan KOENIG (from FRANCE jeudi 5 février 2009 21:02:22)

Reply

Answer 7

Feb 5, 2009 12:12 PM in response to KOENIG Yvan

I suspected that, but our friend Zak is a US resident, so I dismissed the possibility for his case.

Jerry

Reply

Answer 8

KOENIG Yvan

Level 8

41,819 points

Feb 6, 2009 8:51 AM in response to Jerrold Green1

My guess is that the OP applied the format to an empty cell.
After posting he discover his mistake and didn't post about that 😉

Not the first one and certainly not the last one.

Yvan KOENIG (from FRANCE vendredi 6 février 2009 17:51:10)

Reply

Answer 9

DCNV

Level 1

10 points

Apr 4, 2009 9:18 AM in response to zakyak

I just figured this out. Numbers is using the system settings.

Go to the System Preferences panel, and select "International."

Select the middle tab "Formats."

Click on the pick list "Region:" and choose "United States" (NOT "United States (Computer))"

This enables the Thousands Separators [this had really been driving me crazy!]

dc

Reply

Answer 10

zakyak Author

Level 1

4 points

Jun 10, 2009 7:01 PM in response to DCNV

Thank you for your solution. You should send it to Apple as they are clueless. I went back to Neo Office as this seemed hopeless. I thought I would try one more time and see if 09 was different but it wasn't, I checked here and you saved the day. It was driving me crazy too, and I know people thought I was doing something wrong. Again thank you.

zak

Reply

Answer 11

KOENIG Yvan

Level 8

41,819 points

Jun 19, 2009 10:26 AM in response to zakyak

zakyak wrote:
It was driving me crazy too, and I know people thought I was doing something wrong.

I did.
As a French user I never used a "United States (Computer))" keyboard.
I didn't know that there is such a keyboard.

Ignorance is not an excuse so I apologize.

Yvan KOENIG (from FRANCE vendredi 19 juin 2009 19:26:20)

Reply