Toggle sidebar Toggle sidebar
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Changing decimal separator symbol in Excel

P

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 !!!!
 
PJM said:
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 !!!!
Click to expand...

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.
 
Damn, seems like there is no way to change it the Mac version of Excel😕 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 😀 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
 
akadmon said:
Damn, seems like there is no way to change it the Mac version of Excel😕 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 😀 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
Click to expand...

=SUBSTITUTE(cellyouwanttoreferto;".";",")

could also work as well to change . to ,
 
3 years old and still kickin!

And I just found this today and it sure helped. So thanks, kisiro, you just saved my night.
 
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
 
And again 3 years later ...

bidevis tipp works perfectly on Excel Mac 2011.

7. Restart Excel.

🙂
 
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.
 
PJM said:
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 !!!!
Click to expand...

Excel preferences (command+,)
Autocorrect
Replace .
With ,

Now, I can use the numeric keypad of my Mac.I type ., Excel switches to ,
 
You must log in or register to reply here.
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.
Top Bottom
Back