Related Posts
Friday wrist check. Sound off y’all!
Additional Posts in Excel Genius
Google Sheets vs Excel - pros? cons? differences?
What's the F4 analogy in Office 365?
Best pdf to excel converter?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
What do you mean? What data type have you assigned? Can you provide any examples?
Really appreciate the help when you combine multiple excel workbooks together through “get and transform” data inputted out won’t add
Even if I turn numbers to number format
Can you describe in detail what you are doing? Did you declare the data type within power query or you are choosing number format?
Being detailed and specific helps when we can't observe what you're trying to accomplish and how you're doing it.
I tried declaring format and also after table outputted using number format
1. I hit get data
2. From folder (folder contains several workbooks)
3. Hit transform and load data
4. Data comes out in a table
All related workbooks
Table produces looks great
I just can’t add numbers within the table even if in number format
Multiply the numbers by 1.
- manually input 1 to the side of your data, copy it
- highlight the cells you want to convert to number format
- alt + e + s + m (paste special, multiply)