decimals changed to commas

T

tnaga

excel vX for mac.
i have used excel for years, then 3 days ago, all of my excel file
have changed from decimals to commas (ie: 2.33 is now 2,33). formula
do not work using decimals (but commas work). how do i change th
commas back to decimals?
thank you, te
 
G

Gord Dibben

Ted

Not running a Mac, but in Windows OS the comma or dot is set in Regional
Settings in the Control Panel.

Probably a system alteration 3 days ago caused your problem.

Gord Dibben XL2002
 

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
Number Formatting Question 1
Offset Question 5
Commas and periodes 6
Possible to change the default cell format? 4
Currency Settings 1
How to change decimal separator . to , 2
complex number in excel 2003 sp3 3

Top