I am having a hell of a time after using get and transform feature to add the numbers

like
Posting as :
works at
You are currently posting as works at

What do you mean? What data type have you assigned? Can you provide any examples?

like

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)

Related Posts

I got positive feedback from HR after interview rounds, and asked to send required documents for compensation discussion. It's been a week and no response after sharing the docs. How to handle this scenario. I am getting excited but have fear that I will ghosted

Should I wait for some more time?
Should I mail/call HR regarding the update?

like

How are you handling reviews/ reputation management for social media? For multiple (1000) location business? Talking with a client and this is part of scope.

My fashion is in such a rut. I’m wearing the same basic clothes every day. Trying to pay down a lot of debt so I just don’t have a lot of disposable income to buy new clothes. (Continued)

Hi 👋 Does anyone work in fields related to LCA and EPD?
I'm currently employed (2 YOE, background of Environmental Engineering with a master in Circular Economy) but actively searching for a new higher paid company - I live in Spain and make 20k, it's a struggle. These topics are still pretty new over here so there are not many options.
Any recommendation on finding remote jobs (since I only have the Spanish work permit)?
Thanks in advance!

Hello FinTech community!
Currently looking to fill 3 headcount in my team at a London based Series D Unicorn FinTech startup.

Specifically I’m looking for experienced Application Security Engineers.

The team, including these roles are 100% remote, although you must be based in the UK.

If working in an office is more your style, we have the option to book desks on an ad-hoc basis.
We’re currently moving to our brand new office, near London Bridge.

Hope to hear from you!

like

Week of 11 Feb THREAD. BOL everyone! Feel free to post what trades you're planning to make this week. As always, screenshots are welcome.

Post Photo
like

Have a surgeon that exceeds the income threshold for deducting a spousal IRA. Would you recommend one for your clients spouse even if they don’t get the deduction? Why? Trying to learn from the sitch

like

Anyone here willing to refer for a role at Talabat?

like

Can i ask ADP to revise my salary if i have counter offer with more fixed component.

Is a Principal is BCG same as an Engagement Manager at McKinsey?

likehelpful

What are questions I should be prepared to answer in an in interview for an Associate Copywriter role? I used to be in project management, so the questions were different...

All this talk in the news about the virus mutating and becoming more deadly. That's possible, but more likely it weakens

like

I moved back in with my parents in August, and my mom and stepfather have demanded monthly rent. They are in no way poor at this moment in time, and in my opinion it’s f*cked up to demand your child pay rent. I bought a VR headset a couple weeks back and my mom increased the rent because “I can afford it.” Is this normal? I honestly feel used. Fwiw I’ve worked since I was 13, and hustled my entire life.

likefunny

Any recommendations on wedding venues or caterers in jersey? New to the city and don’t really know a lot of people. Looking for medium budget recommendations. Thank you in advance

like

32M
In Sydney, Australia
Nationality: Australian and Pakistani
Religion: Sunni
Profession: Strategy Manager
Hobbies: Hiking, Rock climbing, Travelling, Reading Fantasy fiction, Politics and Self-improvement

Looking for someone from 25-31. Don't care about ethnicity. Practising Muslim. HMU

Hi
How is Broadridge Hyderabad in terms of career growth, work life balance and onsite opportunities.

Hi everyone! How did you discuss with your boss all the time you’d be needing to take off for appointments? My boss absolutely hates when people take time off. Company policy is at least a week ahead of time - she says she needs at least 2. Also when someone requests off a couple days in March then a couple days in April for example, she gets annoyed and says they are requesting too much time (even if they have plenty of PTO available).

like

Anyone with experience going from in house to BL? I’m in tech (M&A, debt finance, securities, general corporate) with 9 YOE but not getting bites when applying to the next tier of jobs at other tech companies. Thinking it may be due to lack of law firm experience and wondering about trying to go to a firm for ~3 years to check that box. Feedback welcome.

like

Friday wrist check. Sound off y’all!

Post Photo
likeuplifting

En direct ou décalé ?

Post Photo

Additional Posts in Excel Genius

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

Anyone use teammates analytics? Does it work well with large worksheet? I am cleaning up this large Excel sheet, it's taking so long I don't even know if it's taking it's time or what.

like

Hi team i have a bit of doubt.
I have an excel sheet where column A is the order numbers. I want to add comments in column G.
There are many repetitions in order numbers but they are all sorted in ascending so all the repetitions are below one another.

If i have a comment, how can i automatically paste that same comment in all the repetitions of that order numbers if i write it in the 1st instance.

Thanks in advance

like

[shortcut genius] how can I use a keyboard shortcut to simulate the double-click on the cross in right low corner that extend your formula only to the row you need (ctrl+d will go too far)

likehelpful

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

Can anyone help me with this pls? I created a graph using data above (not shown) but for some reason “technology” here appears three times. I want sectors to be grouped together. Is there any way to fix this?

Post Photo
like

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

Ok, using excel is not a primary function for my role (this will be very obvious shortly...) So please be kind! On my sheet, in the first and third columns, I have lists of reference numbers. In the second column I have a client name. I already identified the duplicates in the first and third columns using conditional formatting.What I need to find now is column 2 value, whenever value in column 3 is identified as duplicate. Problem is, I have over 120k rows of data so I can't filter! Help!

like

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

like

What's the F4 analogy in Office 365?

like

Whats a good book/course that will teach me advanced excel skills? I want to be quick with shorcuts etc & learn VBA/Macros. Under $30 please, input is greatly appreciated.

like

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
like

Please help. I was recently hired by a Venture Capital firm that uses MacBooks instead of PCs. I’m extremely efficient with Excel on PCs and am struggling with the transition to Mac. Do any Mac users have a list of keyboard shortcuts that they use frequently, or any other tips/tricks?

likefunny

I am having difficulties getting my (Return on ad spend) column displaying correctly. The source data is shown in currency but on the pivot table I am only seeing count and percentage options. Any help would be greatly appreciated.

Post Photo
like

Best pdf to excel converter?

like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal