I am following the below video and trying to do the whole exercise by myself.
https://www.youtube.com/watch?v=McLQ3gEGbHQ&lc=Ugw9AoeEViYfhGVI0HZ4AaABAg.A1CJW38XDsVA1TpC3kLhwZ
I am a little stuck on changing the discount column to percentage. I tried different options while in the powerquery window to convert it to decimal or a number but the same error ("we couldn't convert to number") appeared.
I have not attempted to change the CSV file directly as this is a comma-delimited file and everything should be done as shown on the video.
I will appreciate your help as I have spent some time to figure this out and not winning. I am very determined to get it right on my own.
I am using Excel version 2403 (365) on Windows 11.
Hope to hear from you soon.
Just adding the error page in the forum as it seems not uploaded at first.
The error message did not come through. Please try again.
It might also be useful to know your regional settings in case it's an issue with the decimal point.
I had a look at my Windows regional settings and changed the commna to dot as you were right on this. I went back to the sheet and tried again using both percentage and locale and it seems I am still getting the error. I double check the CSV files as they are all have dots in their discounts column.
