Hi!
I have 2016. Excel for mac.
I need decimal seperator to be ".", so i changed in Mac system prefernces decimal seperator from "," to ".", so now in Excel decimal seperator in cells is ".", but as i draw chart, in chart axis decimal seperator apears ",", and i can't find how to change itScreen Shot 2016-04-21 at 13.06.23.png.
Please Help!
Hi -
In Excel, go to File, Options, Advanced. Under the category Editing Options you should see a check box for "Use system separators". If that's not checked, check it and see if that fixes the problem. If it is checked, uncheck it an change the "Decimal separator" to what you want it to be.
Hope this helps.
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
You've already changed the computer's regional / system settings, right?
Check the separator settings in excel. I've looked around and that can be a little unpredictable but it's the place to go.
Then check:
Chart Tools Ribbon => Current Selection Panel => Vertical (Value) Axis dropdown selection => "Format Selection" Button => Number Pane
From what I can tell, that doesn't actually change the chart settings, but it's the only other place I can think you could change.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks