Hi anyone
For some reason all the numbers I have in excel have now got a "," separator rather than a "." and I have no idea how it happened or how to change it....It is even showing the same in the Format cells drop down....Any help to get this back to normal would be much appreciated
You will do using formula. If you data in "A2"
Forumla in "B2"
Formula:
Please Login or Register to view this content.
Last edited by avk; 01-01-2017 at 07:07 AM. Reason: Addition
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Have your system settings changed? Check in Advanced Options that your separators are set correctly for your locale.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Sorry AVK don't know what your answer means...I'm very novice
AVK is recommending a workaround, but I suggest you work through your settings to get to the root of the problem.
AliGW
Thanks that was the problem....would never have found it myself...and no idea how it happened...but thank you very much....and all the very best to everyone for 2017
You're welcome and Happy New Year!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks