OMG you saved my life. I struggled with the wrong decimal on my mac for YEARS. The general instruction to change the decimal in the language settings didn't work for me. 1000x Thanks!!!
"Text to column" solution and setting the actual decimal and tausend separators works great! Keeps dates intact. Great solution for international .CSV, .TSV and .TXT files! Much appreciated!👍
I watched your vid from article on another site. It appeared so useful, so I took care to go directly to UA-cam to like it. Other sources proposed some clunky methods I was using before, but now I can use your comprehensive methods. Thank you for this.
Awesome! This has been a pain for me to deal with in excel, since my default is set to US/UK while I often need European notations too. Very happy to now know that the formula NUMBERVALUE exists (because the text to columns only works if you want to convert whatever you have to your default). Thank you very much!
Oh, actually, it does not work the way I envisioned... do you know of any way to force excel to use another notation than its default for numbers? I have not been able to find it... I thought the NUMBERVALUE was to do that... ¯\_(ツ)_/¯
Thanks for your very descriptive video, can you pls share the same using Excel for MAC on MAC system because on MAC finding these options is difficult.
amazing! having problem thousands of data in Indonesian format where everything is comma and everything is period this should help me format faster in a very little steps. Thanks
Why do none of these work for me? Is it because I am using a Mac? I tried to set the decimal separator to the point system through my settings, but it did not change anything.
@@vivianeb90 I have the same problem as well. I have tried to restart it, but none of it seems working. When I try to use this method, it goes back to the original settings (where the decimal separator is in a coma). Need help.
OMG you saved my life. I struggled with the wrong decimal on my mac for YEARS. The general instruction to change the decimal in the language settings didn't work for me. 1000x Thanks!!!
"Text to column" solution and setting the actual decimal and tausend separators works great! Keeps dates intact.
Great solution for international .CSV, .TSV and .TXT files! Much appreciated!👍
thank you very much sir. i have been searching for this tutorial for ages! god bless you.
This literally saved my sanity
*THANK YOU*
very useful clip. many thanks chester. i used to this manually and it is really very tedious.
Very useful. I basically needed the last option you gave. Thank YOU!
THANKS SO MUCH! text to column has sorted out my grievance. No other video helped
I watched your vid from article on another site. It appeared so useful, so I took care to go directly to UA-cam to like it.
Other sources proposed some clunky methods I was using before, but now I can use your comprehensive methods. Thank you for this.
Great, thanks for this. The formula option worked great for me.
Awesome! This has been a pain for me to deal with in excel, since my default is set to US/UK while I often need European notations too. Very happy to now know that the formula NUMBERVALUE exists (because the text to columns only works if you want to convert whatever you have to your default). Thank you very much!
Oh, actually, it does not work the way I envisioned... do you know of any way to force excel to use another notation than its default for numbers? I have not been able to find it... I thought the NUMBERVALUE was to do that... ¯\_(ツ)_/¯
thank you a lot! the second method with formula worked for me.
Explicit explanation. I kowtow. I gallivanted around before encountering this video.
amazing! simple and useful options to solve sap exported excel file's discrepancy. This ease my day a lot. Thanks!
Thank you so much for video. I hope you are healty and fine :)
Thanks for your very descriptive video, can you pls share the same using Excel for MAC on MAC system because on MAC finding these options is difficult.
Thanks a lot. Save me from headache
I watched over 10 tutorials, thank you v.much
Thank you so much for this video. That last option helped me a lot!! So grateful. 🙏🏽
This video just saved my day. Thanks for sharing ❤
very much concise and clear understanding
Thank you very much, i hit the like button like that it has collapsed :)
Thank you so much!
Thank you. The big formatting issue is resolved.
The number value helped thank you
amazing! having problem thousands of data in Indonesian format where everything is comma and everything is period this should help me format faster in a very little steps.
Thanks
thanks
Its very useful and easy to understand from you
Thank you so much, it was really helpful
Great, easy to use!
Thank you verty much. You have saved me a lot of time!😂
Thank you, you saved my day!
Very informative, Thanks!
Thanks saved me some time!!!
Thank you, it really helped :) wish you a good dat
Finally! Thanks mate!
Thank you Sir
thank you. good job.
Great video, I can't thank you enough.
Great. Is it possible to do the same using "POWER QUERY"?
Why do none of these work for me? Is it because I am using a Mac? I tried to set the decimal separator to the point system through my settings, but it did not change anything.
Ok, it seems that all I needed to do was restart excel. Took me forever to find that little detail.
@@vivianeb90 I have the same problem as well. I have tried to restart it, but none of it seems working. When I try to use this method, it goes back to the original settings (where the decimal separator is in a coma). Need help.
thank you
Very usefullll
You should have this also under title How to Fix Excel Numbers That Don't Add Up I haven't seen coma and it should have been full stop
Thank you. I'm trying to change $15,444 to $15.4 How do I do this?
Finally!
This video works if you originally have a UK locale configuration. It doesn't work for an european configuration.
Why no one works to me 😭😭😭😭🤯🤯🤯🤯
Thank you Sir
thank you