excel formula to place a colon for mac address

Language Control Panel – Language Preferences

In the Language Control Panel, click Change date, time, or number formats.

In order to find the List Separator settings, head to your Start Menu and type Language.

Remember, this tutorial was done in Windows 10. Anyway, in addition to the step by step instructions, I prepared screenshots to keep you interested. So you still want to continue this 99 pager post? (whaaat? asdfghjkl!). įor those who want to have the step by step instructions, read on (ughh). To cut the story short, you’ll have to change the setting List Separator in the Language Settings (seem pretty simple - and legit). The exact step by step instructions might be different in other Windows platform but in the end you’ll just have to tinker with your Language settings. However, I won’t be giving you a hard time to solve this one so I’ll just give you the exact instructions (Yay!).

I tried to find it on my own using the single clue I got over the inter-webs, the “Language Settings”. Since I am a super lazy kid, I did not bother trying to find the exact solution over the internet. Now according to my research, this problem exists because of a certain language setting. I also experienced that and as a user that usually use commas in separating Excel formulas, this is quite annoying.īut fear not! We have a solution for that. You may have wondered why suddenly Microsoft Excel is using semicolons ( ) instead of commas (,) in separating your Excel formulas.

Comma as formula separator Semicolon as formula separator

Excel formula to place a colon for mac address