Forum Discussion
CSV Files
I have to use a CSV file. I download and save it. Then open Xcel and import it via the data import and semicolon function. It imports the figures eg 12345. However I need to put decima...
Hi Sergei
Thank for your reply. The problem is there is over 200 lines with at least 6 columns with numeric , on that basis the manual option is a non starter. Interesting that the colleague in Netherlands also uses the same method, however when the CSV is opened , it works as it should without the import or modifying the figures.
Thank for your reply. The problem is there is over 200 lines with at least 6 columns with numeric , on that basis the manual option is a non starter. Interesting that the colleague in Netherlands also uses the same method, however when the CSV is opened , it works as it should without the import or modifying the figures.
If it is imported by Power Query that's not an issue, you just divide on 100 during the transformation. If using legacy From Text wizard - I don't know the way for such transformation.