Feb 24 2021 03:00 PM
Hi everybody,
please have a look on my file, i'm trying to convert some data and i'm facing few inexplicable problem.
I have allready try many solution but it is not working as i want.
in the best before and after you will see the data. many of them are well converted with different solution that i tried in my macro but some cell it doesn't work automatically. i have tried column to text, paste special, substitute but nothing working well.
is somebody could explain me what's is happening?
thanks
@Faraz Shaikh ?? :)
Feb 28 2021 07:33 AM
Hi @debou7001,
As far as I understand looking at the file, you are trying to convert the decimal value for "," into a "."
You can convert the same following
1. Power Query changing the data type
2. Writing the formula in the cell as showed in each screenshot
I'm attaching the file you can have a look
Hope this is workable for you.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.
Mar 15 2021 04:55 AM
Mar 15 2021 05:27 AM
With Text to Columns you shall select proper separators on the third step of the wizard. As they are in source data, not in your locale.