Gorgiewave Posted February 21, 2018 Share Posted February 21, 2018 I'm trying to make a graph in Excel. My laptop has Spanish settings, which means the axis has numbers with commas instead of decimal points and vice versa. 0.35 in English is 0,35 in Spanish and 1,000 in English is 1.000 in Spanish. The axis doesn't seem to allow manual editing. Is there some way to allow it or otherwise to change the axes? Any help would be appreciated. Quote Link to comment Share on other sites More sharing options...
jamboj Posted February 21, 2018 Share Posted February 21, 2018 There are ways to change the labelling of the axis. What is it you're trying to achieve exactly? Quote Link to comment Share on other sites More sharing options...
Gorgiewave Posted February 21, 2018 Author Share Posted February 21, 2018 6 minutes ago, jamboj said: There are ways to change the labelling of the axis. What is it you're trying to achieve exactly? The axis has 0,1 0,2 0,3, etc. I want it to say 0.1, 0.2, 0.3. It's the axis itself, not the name of the axis. Quote Link to comment Share on other sites More sharing options...
milky_26 Posted February 21, 2018 Share Posted February 21, 2018 3 minutes ago, Gorgiewave said: The axis has 0,1 0,2 0,3, etc. I want it to say 0.1, 0.2, 0.3. It's the axis itself, not the name of the axis. would changing the format of the cells you are using for the graph work? I'm not sure if there is an option to change from european formatting to british Quote Link to comment Share on other sites More sharing options...
Gorgiewave Posted February 21, 2018 Author Share Posted February 21, 2018 8 minutes ago, milky_26 said: would changing the format of the cells you are using for the graph work? I'm not sure if there is an option to change from european formatting to british In Spanish settings, Excel doesn't recognise 0.1. It thinks it's zero full stop one and meaningless and doesn't do any calculations with it. Quote Link to comment Share on other sites More sharing options...
gjcc Posted February 21, 2018 Share Posted February 21, 2018 Had a similar problem a while back when doing work for uni. Clicked: File/Options/Advanced... then it gave the option of choosing what you wanted in place of the comma. Not sure what edition that was, nor if it would carry over to the graphs. Quote Link to comment Share on other sites More sharing options...
Tazio Posted February 21, 2018 Share Posted February 21, 2018 Couldn't you download something like Open Office that is compatible with Excel? Quote Link to comment Share on other sites More sharing options...
Sydney Posted February 22, 2018 Share Posted February 22, 2018 Download an English language pack? https://www.techwalla.com/articles/how-to-change-the-language-in-microsoft-excel Quote Link to comment Share on other sites More sharing options...
Alex Posted November 22, 2018 Share Posted November 22, 2018 Hi, bumping this as i need to send out a mail merge using data from an excel spread sheet as the source. I have columns with decimal points which I have rounded up using the -> .00 function. How do I entirely remove the decimal points from its memory so that only the rounded number goes out in the mail merge? Thanks for any help Alex Quote Link to comment Share on other sites More sharing options...
Fifejambo 51 Posted November 22, 2018 Share Posted November 22, 2018 Use formula =round(cell ref,0) Quote Link to comment Share on other sites More sharing options...
Ribble Posted November 22, 2018 Share Posted November 22, 2018 23 minutes ago, Alex said: Hi, bumping this as i need to send out a mail merge using data from an excel spread sheet as the source. I have columns with decimal points which I have rounded up using the -> .00 function. How do I entirely remove the decimal points from its memory so that only the rounded number goes out in the mail merge? Thanks for any help Alex Use '=round(a1,0)' for the rounding then copy and paste as text Quote Link to comment Share on other sites More sharing options...
Alex Posted November 22, 2018 Share Posted November 22, 2018 Thank you! I've been fiddling for ages, you saved me a lot of work. Quote Link to comment Share on other sites More sharing options...
Dunks Posted November 22, 2018 Share Posted November 22, 2018 9 hours ago, Alex said: I've been fiddling for ages Quote Link to comment Share on other sites More sharing options...
Alex Posted November 23, 2018 Share Posted November 23, 2018 21 hours ago, Dunks said: Quote Link to comment Share on other sites More sharing options...
SupaJT Posted November 23, 2018 Share Posted November 23, 2018 Is your laptop region set to UK in control panel? Quote Link to comment Share on other sites More sharing options...
Spellczech Posted November 24, 2018 Share Posted November 24, 2018 For the original question, Google is your friend: https://www.extendoffice.com/documents/excel/3785-excel-convert-european-number-to-us.html Quote Link to comment Share on other sites More sharing options...
Bridge of Djoum Posted November 24, 2018 Share Posted November 24, 2018 (edited) Wait, you never thought to ask Sergey? Edited November 24, 2018 by Bridge of Djoum Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.