Decimal point vs comma

A

Antje

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) when entering normal numbers in cells using decimal point it will not autosum. by using a comma in place of decimal point no problem. i must have a setting wrong
 
C

CyberTaz

The "wrong setting" most likely is in your OS X System Preferences. Go to
the 'Language & Text' Preferences & adjust your 'Region' and/or 'Numbers'
formats. Excel will pick up on the changes when you next launch it.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

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

Formatting a Cell with a number without a decimal point 3
How do I align currency decimals in cells? 2
Autosum not highlighted 3
Text changes to hashes 3
Comments in Excel 2
FORMATTING CELL 6
Bug in Excel 2004 with Mac OS X 10.5 0
Multiple Worksheets 1

Top