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

Excel does not accept text format! 0
Offset Question 5
Number Formatting Question 1
Mail Merge - displaying a conditional number of decimals 5
Using project as a resource tracker 0
Help with loop 4
How to change decimal separators when importing text (csv) files? 1
Commas and periodes 6

Top