On the understanding that the numbers you want to change start in cell A1 and you don't mind converting the numbers to text then the following formula should work. =SUBSTITUTE(SUBSTITUTE(TEXT(A1,"#,##0.00"),",",".",1),".",",",2)
Hi I do have another tutorial that would help you: ua-cam.com/video/opDTKAkIY5k/v-deo.html The formula is rather long but it will at least allow you to drag to the right and solve your multiple column problem. =VALUE(SUBSTITUTE(LEFT(A1,LEN(A1)-3),".","",1) & SUBSTITUTE(RIGHT(A1,3),",",".",1)) Hope it helps you
Hi, thank you for the tutorial. My problem is that I bought a laptop and software in Europe but prefer to use the UK Format as that is what I've been doing all these years. How do I make my new excel default to such? I couldn't find that in the options. TIA.
Your video is very clear and very well explained but, living in Spain, I need exactly the other way round in an already excel sheet with many columns. Could you please help me with that? Thank you so much
I am curious why we don't using points after 3 numbers as most of Europe here in Czech Republic, we are using just empty space in large numbers and comma for decimal. But I know point is used in banks because if there is empty space, someone could write something into that and change that number. Same in post office, but there is mostly - symbol instead of point. If you want send something for money and you write price for example 5 000 Kč, post office worker will probably instert - symbols there so it will be 5-000-Kč or 5/000/Kč then so nobody can change that to 500000Kč. :-)
@Computer Tutoring: Be carefull : in the french system, there is a slight difference. The thousand separator is a space (" ") but the decimal still the comma ",". US => 45,266.11 European => 45.266,11 French => 45 266,11 (i'm a frenchman).
Hi! I tried it with my file (currency is in eur to gbp) but nothing seems to be working. Even the summation also didnt work. Is it because of the installed version of excel? Mine is in German so even I try to use replace it is getting replaced but the calculation doesnt get summed up. 😔
@@girlofephemeras4253 Hi sorry it didn't work it. The version shouldn't be the problem you could try flash fill. ua-cam.com/video/DspxFZHs9gw/v-deo.html. It's not the exact formula but hopefully it gives you the idea. Alternatively if you're looking for a formula you could try: ua-cam.com/video/opDTKAkIY5k/v-deo.html though this is a little more complicated when compared to Flash Fill but you'll have a fire and forget formula.
Hi. This video helped me alot but I have a follow up question. After the conversion from European to American currency, how do I move the decimal placement? For example, it reads it as $20,088 instead of $200.88.
20088 should be converted to 20,088.00 based on the above video maybe just check the decimals and comma delimiters are correct in the text to columns section of the tutorial
Great, thanks a lot! Your solution works also when importing from a text file. The same wizard appears. Well done
Magic glad you found it helpful
Thank you! I was looking for a simple solution like this one :D
Glad it helped 😁
SO HELPFUL, THANKS
Glad it helped
Thank you for your solution! This saved me a lot of time and effort. :)
Glad it helped sorry it's taken ages to reply but I have noticed 😁😁
Well done.
Thanks 😊
Thanks for sharing. I was wondering if you can show us how to convert the U.S. number to European format. Thank you!
On the understanding that the numbers you want to change start in cell A1 and you don't mind converting the numbers to text then the following formula should work.
=SUBSTITUTE(SUBSTITUTE(TEXT(A1,"#,##0.00"),",",".",1),".",",",2)
Fantastic! Thank you!
Awww shucks ☺
Big like for this! Thanks!
Glad it helped!
Is there a way to do this on multiple columns at once and overwrite the data?
Hi I do have another tutorial that would help you: ua-cam.com/video/opDTKAkIY5k/v-deo.html The formula is rather long but it will at least allow you to drag to the right and solve your multiple column problem.
=VALUE(SUBSTITUTE(LEFT(A1,LEN(A1)-3),".","",1) & SUBSTITUTE(RIGHT(A1,3),",",".",1))
Hope it helps you
Hi, thank you for the tutorial.
My problem is that I bought a laptop and software in Europe but prefer to use the UK Format as that is what I've been doing all these years.
How do I make my new excel default to such?
I couldn't find that in the options.
TIA.
Your video is very clear and very well explained but, living in Spain, I need exactly the other way round in an already excel sheet with many columns. Could you please help me with that? Thank you so much
ua-cam.com/video/QzNxFah1jjM/v-deo.html
Does this tutorial help?
May I know the Auto correction formula for British standard to German standard
ua-cam.com/video/opDTKAkIY5k/v-deo.html hope this gives you the formula you need.
I am curious why we don't using points after 3 numbers as most of Europe here in Czech Republic, we are using just empty space in large numbers and comma for decimal. But I know point is used in banks because if there is empty space, someone could write something into that and change that number. Same in post office, but there is mostly - symbol instead of point. If you want send something for money and you write price for example 5 000 Kč, post office worker will probably instert - symbols there so it will be 5-000-Kč or 5/000/Kč then so nobody can change that to 500000Kč. :-)
Intriguing - Will def have to do a Google
@Computer Tutoring:
Be carefull : in the french system, there is a slight difference. The thousand separator is a space (" ") but the decimal still the comma ",".
US => 45,266.11
European => 45.266,11
French => 45 266,11
(i'm a frenchman).
Brilliant thanks for that wow from a real French man will double check in future
So helpful!!!!
Glad it helped - happy converting! 😀
Hi! I tried it with my file (currency is in eur to gbp) but nothing seems to be working. Even the summation also didnt work. Is it because of the installed version of excel? Mine is in German so even I try to use replace it is getting replaced but the calculation doesnt get summed up. 😔
@@girlofephemeras4253 Hi sorry it didn't work it. The version shouldn't be the problem you could try flash fill. ua-cam.com/video/DspxFZHs9gw/v-deo.html. It's not the exact formula but hopefully it gives you the idea. Alternatively if you're looking for a formula you could try: ua-cam.com/video/opDTKAkIY5k/v-deo.html though this is a little more complicated when compared to Flash Fill but you'll have a fire and forget formula.
Hi there! Thanks. I will definitely give this a try! Such a nice thing getting help from you. Take care!
@@girlofephemeras4253 My pleasure
Thank you!!!
Thank you so much!
Hi. This video helped me alot but I have a follow up question. After the conversion from European to American currency, how do I move the decimal placement? For example, it reads it as $20,088 instead of $200.88.
20088 should be converted to 20,088.00 based on the above video maybe just check the decimals and comma delimiters are correct in the text to columns section of the tutorial
I find it to be excellent!
Excellent Indeed :)
whats up with the spa music man :-)
That was my best piano playing :) Alright I'll tone it down in the future
God bless you is all I can say...phew
Thank you so much for saying I feel that I'm gonna have a great day already