How to change decimal separator . to ,

M

MG

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.
 
N

Niek Otten

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

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

Bob Phillips

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)
 

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

How to change decimal separators when importing text (csv) files? 1
complex number in excel 2003 sp3 3
Possible to change the default cell format? 4
Convert number with comma to number with dot 2
Decimal Points and comma separators 2
Convert number to text and add comma separator for thousands 2
Decimal point in bar chart and similar 1
Decimal dot to Decimal Comma 3

Top