Active Member
March 27, 2024
I am following the below video and trying to do the whole exercise by myself.
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.
Trusted Members
Moderators
January 31, 2022
Trusted Members
Moderators
November 1, 2018
Active Member
March 27, 2024
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.
1 Guest(s)