Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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, 21 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Decimal tabs with space as thousands separator harry Word 1 12-22-2023 02:59 PM
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
Changing decimal separator in charts (comma to dot) thousands comma separator taylormayd Excel 3 02-20-2009 03:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:57 PM.


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