excel format cell

how I change a format 123,45 to 123.45

OS X Mavericks (10.9.1)

Posted on Mar 8, 2014 6:13 AM

Reply
3 replies

Mar 8, 2014 7:05 PM in response to Abraham Bemerguy

I think you may be looking for this. It's a global change to your settings, which will apply to Excel.


Have Excel closed before checking:


1) On main tool bar click the apple, and select "System Preferences".

2) Select "Language & Region"

3) In this window select "Advanced..."

4) You will see : "Number separators:" With settings for Grouping & Decimal.


Check these to see if they are correct for your region. Set them to what you want restart Excel and see if it correct it. You'll notice at the bottom of the window it shows an example of the settings.


You may want to check all the settings like currency, measurements, dates, time, ...etc.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

excel format cell

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.