Forum Discussion
I need Help with the web import in excel
Hallo all i need help and dont know wath to do. If i Import somthing from the in Excel i kan not use it. I can not add the Numbers ore do anithing witz it i have allways the same bug. #value! in ger...
Hello,
the Get & Transform features lets you import data from websites too. I attached a sample, where I did some formattings in the query editor. You may do additional formattings, e.g. replace M and B by their meanings. Note: I did this in Excel German, so the steps are in German.
Best,
Mourad
Mourad, as a comment - here is always two digits in decimal part in right columns, thus we may replace first dot on nothing and after that M and B on 4 and 7 zeroes accordingly plus apply Whole Number type finally. If do step by step in UI.