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 decimal point in to show 123.45. When I trying adding the decimal placing it shows as 12345.00.
Has anyone come across this ?
Many Thanks
3 Replies
To show 12345 as 123.45 you need to manually add the dot between 3 and 4; or divide above number on 100 and keep result in another cell.
- 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.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.
