How to change decimal separator . to ,

How to change my Mac exel so that it does not use dots as decimal
separator and commas as separator for thousands? I would require it to
be the other way a round. As you can imagine it is a litle annoying
when the excel does not understand the local way of handeling numbers.

If your version of Excel is new enough (don't know exactly from which
version):

Tools>Options>International tab, gives you the choice.

--
Kind regards,

Niek Otten

"MG" <[email protected]> wrote in message
news:[email protected]...
> How to change my Mac exel so that it does not use dots as decimal
> separator and commas as separator for thousands? I would require it to
> be the other way a round. As you can imagine it is a litle annoying
> when the excel does not understand the local way of handeling numbers.
>

On a Win PC, this is determined by the Regional Settings in the control
panel. Don't know about Mac, but if you have a control panel and regional
settings, check those.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MG" <[email protected]> wrote in message
news:[email protected]...
> How to change my Mac exel so that it does not use dots as decimal
> separator and commas as separator for thousands? I would require it to
> be the other way a round. As you can imagine it is a litle annoying
> when the excel does not understand the local way of handeling numbers.
>