« Special Symbols on the Keyboard (helps in Excel) | EXCEL an application of NO USE!!! » |
Missing Comma in millions place (quick tip)
How-to's, Excel TipsHi there,
I have a small tip for you today. Do you know why comma is missing in millions place for this number 12345,678.90. Yes, even I wasn't know since yesterday.
Nothing to worry! here is how we can avoid such dragons in Excel.
...
Goto-->windows start button --> type Region and Language --> hit ENTER
here a window will popup with FORMAT as first tab in that goto format and replace English (Trinidad and Tobago) to English (United States).
Note: This tip is applicable for those who face comma issues. My system by default showing English (United States).
That's it, now check the number which is added with commas.
Magic works!!!
DOWNLOAD working file. xls from here.
If you like this video, please share it on your social networking sites by clicking on the icons placed around the blog. If you want to support me for maintaining this blog REGISTER here. It's absolutely free and in bonus you will receive monthly newsletters and updates from us.
CLICK HERE FOR MORE TIPS: EXCEL TIPS
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments