Changing decimal separator symbol in Excel

[PJM]

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]

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]

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

 

[kisiro]

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

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

could also work as well to change . to ,

 

[Gregg2]

Cool. But the post before yours is nearly 2-1/2 years old.

 

[Angyal]

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]

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]

And again 3 years later ...

bidevis tipp works perfectly on Excel Mac 2011.

7. Restart Excel.

 

[PhilBoogie]

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]

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 ,