Microsoft Office Forums Changing decimal separator in charts (comma to dot)

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-01-2016, 05:28 AM
N_Aggelopoulos N_Aggelopoulos is offline Changing decimal separator in charts (comma to dot) Windows 7 64bit Changing decimal separator in charts (comma to dot) Office 2013
Novice
Changing decimal separator in charts (comma to dot)
 
Join Date: Mar 2016
Posts: 3
N_Aggelopoulos is on a distinguished road
Default Changing decimal separator in charts (comma to dot)

In most (maybe all) European languages other than English, a comma is used as a decimal separator where in English there is a dot. So the German version of Microsoft has the comma as the default decimal separator. It is possible to change this in Excel and have the dot as the decimal separator. However, when importing a graph from Excel to PowerPoint, the values revert to having a comma as a decimal separator, so 0,5 rather than 0.5. Since I want to make my presentation to a scientific conference where English is the official language, I would like to use throughout the PowerPoint presentation (including graphs imported from Excel) the English style, with the dot. It seems that changing the language to English does not affect what decimal separator is used in the graphs. Is there some other way to achieve this?



I attach a graph imported from Excel into PowerPoint to illustrate the problem. In Excel, the commas had been changed to dots by editing the advanced settings but when the graph is imported to PowerPoint, the decimal separator reverts to the comma.
Attached Files
File Type: pptx decimal_separator_problem.pptx (34.6 KB, 11 views)
Reply With Quote
  #2  
Old 03-01-2016, 09:33 AM
JohnWilson JohnWilson is offline Changing decimal separator in charts (comma to dot) Windows 7 64bit Changing decimal separator in charts (comma to dot) Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,791
JohnWilson will become famous soon enoughJohnWilson will become famous soon enough
Default

Pretty sure in PowerPoint that is controlled by the Windows Region & Language settings in Control Panel.

If you set this (temporarily) to English you should see the period as decimal separator. Not sure if that will cause other problems though.
__________________
Microsoft PowerPoint MVP
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #3  
Old 03-03-2016, 09:52 AM
N_Aggelopoulos N_Aggelopoulos is offline Changing decimal separator in charts (comma to dot) Windows 7 64bit Changing decimal separator in charts (comma to dot) Office 2013
Novice
Changing decimal separator in charts (comma to dot)
 
Join Date: Mar 2016
Posts: 3
N_Aggelopoulos is on a distinguished road
Default

Quote:
Originally Posted by JohnWilson View Post
Pretty sure in PowerPoint that is controlled by the Windows Region & Language settings in Control Panel.

If you set this (temporarily) to English you should see the period as decimal separator. Not sure if that will cause other problems though.
I have the language as British English (on the German version of Microsoft Office) but the comma remains. I hope there is a solution other than travelling to the UK or USA to buy Microsoft Office.
Reply With Quote
  #4  
Old 03-03-2016, 10:43 AM
JohnWilson JohnWilson is offline Changing decimal separator in charts (comma to dot) Windows 7 64bit Changing decimal separator in charts (comma to dot) Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,791
JohnWilson will become famous soon enoughJohnWilson will become famous soon enough
Default

Just to check when you say the language is set to British English you do mean in Windows > Region and Language not Office spell check.
You can check the decimal separator in Additional settings



__________________
Microsoft PowerPoint MVP
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #5  
Old 04-06-2016, 04:51 AM
N_Aggelopoulos N_Aggelopoulos is offline Changing decimal separator in charts (comma to dot) Windows 7 64bit Changing decimal separator in charts (comma to dot) Office 2013
Novice
Changing decimal separator in charts (comma to dot)
 
Join Date: Mar 2016
Posts: 3
N_Aggelopoulos is on a distinguished road
Default

Thank you for your efforts and sorry for not replying earlier but reversing the use of comma and dot is not available under Additional Settings. The only option for the decimal symbol is the comma and for the digit grouping symbol the dot.

EDIT: My apologies, reversing the use of the comma and dot turns out to be possible under the Additional Settings once the language is changed from German to English. Thanks! +rep

Last edited by N_Aggelopoulos; 04-06-2016 at 11:01 AM.
Reply With Quote
  #6  
Old 04-07-2016, 04:56 AM
JohnWilson JohnWilson is offline Changing decimal separator in charts (comma to dot) Windows 7 64bit Changing decimal separator in charts (comma to dot) Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,791
JohnWilson will become famous soon enoughJohnWilson will become famous soon enough
Default

Good to know!
__________________
Microsoft PowerPoint MVP
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal jadess916 Excel 1 06-26-2014 03:48 AM
Changing decimal separator in charts (comma to dot) Decimal alignment of numbers that use blank space as a thousands separator Aston Word 1 07-24-2012 11:44 PM
Changing decimal separator in charts (comma to dot) Comma style without trailing zeroes but with decimal part Scaffold Excel 3 10-22-2011 11:08 PM
Decimal tabs with space as thousands separator harry Word 0 10-05-2010 03:22 PM
Changing decimal separator in charts (comma to dot) thousands comma separator taylormayd Excel 3 02-20-2009 03:46 AM


All times are GMT -7. The time now is 05:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft