Changing decimal separator symbol in Excel

PJM

macrumors newbie
Original poster
Oct 16, 2007
29
0
I need to use comma (,) as decimal separator instead of point (.) in Excel 2004. I have already tried changing the system settings, but it didn’t work. Does anyone know how to do that? Thanks in advance !!!!
 

Big-TDI-Guy

macrumors 68030
Jan 11, 2007
2,605
11
I need to use comma (,) as decimal separator instead of point (.) in Excel 2004. I have already tried changing the system settings, but it didn’t work. Does anyone know how to do that? Thanks in advance !!!!
If it's anything like the Windows version - right click on the cell(s) / rows or columns you want to modify, and under "format cells" tab - there should be a tab on "numbers" - somewhere within the "custom" settings should be what you're looking for.

If you're just trying to change the separators - Tools Menu - Options - International Tab - Separators (uncheck "use system separators - and put in what you'd rather have) then click "ok".

Again, this is for WINDOWS Office 2003. But I could imagine there is at least a little bit of consistency between the two versions... I kinda hope... If not, I've just wasted 15 minutes of my time, and 2 of yours.
 

akadmon

Suspended
Aug 30, 2006
2,007
2
New England
Damn, seems like there is no way to change it the Mac version of Excel:confused: Changing Formats in the International System Pref pane has no effect on Excel.

If all you need to do is diplay the numbers with the comma separator, I've put together a simple :D formula that will do the trick. The way I have set it up here is to display 2 digist after the comma, but you can easily customize it to suit your needs.

=FLOOR(A1,1)&","&MID(TEXT(ROUND(A1-FLOOR(A1,1),2),"0.00"),FIND(".",TEXT(ROUND(A1-FLOOR(A1,1),2),"0.00"))+1,2)

A1 above could be any cell reference
 

kisiro

macrumors newbie
Mar 31, 2010
1
0
Damn, seems like there is no way to change it the Mac version of Excel:confused: Changing Formats in the International System Pref pane has no effect on Excel.

If all you need to do is diplay the numbers with the comma separator, I've put together a simple :D formula that will do the trick. The way I have set it up here is to display 2 digist after the comma, but you can easily customize it to suit your needs.

=FLOOR(A1,1)&","&MID(TEXT(ROUND(A1-FLOOR(A1,1),2),"0.00"),FIND(".",TEXT(ROUND(A1-FLOOR(A1,1),2),"0.00"))+1,2)

A1 above could be any cell reference
=SUBSTITUTE(cellyouwanttoreferto;".";",")

could also work as well to change . to ,
 

Angyal

macrumors newbie
Jan 31, 2011
1
0
3 years old and still kickin!

And I just found this today and it sure helped. So thanks, kisiro, you just saved my night.
 

bidevi

macrumors newbie
Jan 15, 2009
2
0
This is how you change the delimiter

On a Mac
1. System Preferences
2. Language & Text
3. Formats
4. Numbers => Customize
5. Adjust Decimal/Thousands for Number Separators / Currency Separators
6. OK
 

Macsimize

macrumors newbie
Jan 16, 2014
1
0
And again 3 years later ...

bidevis tipp works perfectly on Excel Mac 2011.

7. Restart Excel.

:)
 

PhilBoogie

macrumors newbie
May 15, 2014
12
1
Without changing any System Settings, entering a period (.) on the numeric keyboard resulted in a comma (,) in Excel 2011. In Excel 2016 this doesn't work anymore and there are no settings in Excel Prefs to alter this behaviour.
 

ceciliodaher

macrumors newbie
May 2, 2018
1
0
I need to use comma (,) as decimal separator instead of point (.) in Excel 2004. I have already tried changing the system settings, but it didn’t work. Does anyone know how to do that? Thanks in advance !!!!
Excel preferences (command+,)
Autocorrect
Replace .
With ,

Now, I can use the numeric keypad of my Mac.I type ., Excel switches to ,