I recently inherited a laptop from an employee who has resigned.
The computer has Office 2016 installed, when I enter formulas there is a difference on my old 2010 Office Excel I used a comma (,) as a separator in formulas the 2016 uses a Semi Colon ( ; )
Though it's not a problem I wondered why, is this standard in 2016?
Last edited by Derrick T. Davidson; 12-08-2015 at 02:15 AM. Reason: Typo error
probably regional/language settings
http://www.solveyourtech.com/change-...ist-separator/
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Everything is in Philippine Excel and OS Windows 10?
Last edited by Derrick T. Davidson; 12-08-2015 at 02:16 AM. Reason: Typo error
Point of information: it's a semi-colon, not a colon.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.
Forum Rules (updated September 2018): please read them here.
How to use the Power Query code you've been given: help here. More about the Power suite here.
Correct Ali so sorry
Last edited by Derrick T. Davidson; 12-08-2015 at 02:17 AM. Reason: Typo error
did you check into this particular menu? ...or equivalent
http://cdn.solveyourtech.com/wp-cont...eparator-3.jpg
other than that i dont know any other place where one can change something like that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
More Information
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks