get & transform data (power query)
2 TopicsGet & Transform Data (Power Query)
Hello I have 3 tables on 3 different sheets(tabs) of the same excel file and I and I have them appended into one table on another sheet(tab) of the same file. Issue.... The columns of the appended table are rounding some currency columns to the nearest .00, which is not what I want. If a total is supposed to be $25.29, I want to see $25.29. But instead I see $25.00. I have tried to click on "Launch Power Query Editor" so I could potentially change the formatting of the columns, but nothing happens. I can't seem to get the editor to open as I was when I first created the table. How do I get the Editor to open? I have tried clicking on the Query in the list of Queries and then click Edit, this doesn't work either. I was reading some other posts online and it seems there might be a bug with Excel? I just need to get the editor to open so I can edit the appended table Information...... The 3 original tables have the columns formatted and calculating correctly. The columns on the appended table are formatted correctly, but data does not match the data from original table1.4KViews0likes5Comments