all these years I've been converting text to number and crashing my workbooks, then find out about =VALUE () 🤯

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

Multiple by 1 through “Paste Special > Multiple” works for me and is pretty slick. No need to add columns in the data set.

likehelpful

Make it -1 to make all numbers negative. It’s what I used to do with performance scores back when we had them.

(Yes, I’m kidding.)

like

Also see T() and N()

likeuplifting

Text-to-Columns does the same and doesn’t require adding a column to make the formula/pasting as values, etc.

like

Related Posts

Eid Mubarak Fam!!!

like

For those in NYC where do you go to meet woman? Without having to go get drinks? I don’t drink that’s why I said without drinks.

Anyone working in sustainability?

like

I work for a small organization and we are looking to compare our staff structure to others. Would anyone be willing to share an org chart we have about 50 employees. Looking for titles and levels. Or if you know where I can look for some info that would be great.

like

Which is good to join..Publicis sapient or LTI?

like

no one:
every tech manifesto:

Post Photo
funnylike

Got an offer fr vmware worried about job security should I join or not as I have heard frequent layoffs happen there specially in india VMwware ,kindly suggest what to do !

like

Hi folks, I need some advice on expected CTC

I'm experienced in Celonis Process mining technology and I'm looking for a switch.

Highest qualification: MBA
YOE : 2 years (all relevant)
Current CTC: 10.05 LPA

What should be my CTC expectations for consultant roles in this technology considering process mining is currently a sought after field ?

Pls help

like

Who can relate? 🥴😂

Post Photo
likefunny

Does your boss know your SO/spouse?

like

Anyone here start losing hair at a young age/ how do you shave your head and keep looking professional

like

How do you and your significant other split expenses such as rent and eating at restaurants? We are in our late 20s, not married, she works in tech and makes ~$150k while I am an Associate making ~$400k. We split our $4500 rent based on income so I pay 70% rent and I pay for all meals at restaurants (we eat out ~4 meals per week lunch or dinner). Interested in hearing how you all split these expenses and how your income splits between your partner

like

Hi y’all, I am a Design Strategist at a Minneapolis AD agency. I have 3 years of Ad experience, switched from corporate environment. If this year taught me anything it’s not to be surprised. After George Floyd I can’t help but judge my environment and how senseless and apathetic non-BIPOC people can be to our realities. A whole pandemic going on, a few days away from the election and I got laid off. I’m a Black woman with a strong work ethic, if anyone has career advice please share. Thank you!

like

Any recommendations for a Tax accountant? Thanks!

like

Is there a major dip coming? Thoughts?

like

Hello fishes,
Can anyone please refer me at
IBM. Please DM me i will share my resume..IBM

like

I have come for RTO after withdrawing resignation only to hear from the security guard that I'm TERMINATED from client end! I have not received a single mail on it. Rather, Accenture retained me for the same client's project. My AVP, Manager, HR all aware. They are telling I'm on Accenture payroll. I got a re on-boarding email from client end today too. What's going on?

like

Who do I start and who do I leave on bench?
3/6 0.5 ppr
J Jones, C Godwin, C Kupp, R Woods, DJ Moore, DJ Chark

like

What are agencies looking for in a cover letter? How risky and “creative” can I be? If anyone has a good example, that would be so helpful. (My current job did not require one.)

like

Additional Posts in Excel Genius

What are your favorite excel macros to make you more efficient at work?

like

I have a workbook with a couple of custom lists that we use every month in my department. I'm handing off this responsibility to someone else who will be using their own laptop to do it. Will the custom lists pull over to their version, or do we have to set them up in their version of excel on their laptop?

like

Excel Geniuses, please help:

Is there a way to display data in a Scatter chart (or any chart for that matter) that changes based on a condition (IF, AND, OR)?

For instance, if I have a list of data populated with A or B, and I only wanted to show “A” data points in my chart, can I do that formulaically, or so I have to manually select all the A’s in the data set to show in the chart?

like

Favorite Excel shortcuts or formulas that are not so well known?

likesmart

How do you convert round edges of a chart to sharp?

like

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

Can anyone provide a reference to how to efficiently create and link an excel spreadsheet into a ppt (and make it dynamic). Thanks in advance!

like

What is a website I can use that has live updates of data in tables, that occur every 5 minutes or less, so I can test the Refresh button for queries and connections? …Also, if anyone has a good macro for a button that I can insert into a spreadsheet that you can click as a short cut to the refresh all button, I’m small ears. Thanks!

like

Trying to count the maximum number of overlaps in at a given time in a series of date ranges. Finding an overlap is easy, but not sure how to cycle through date ranges while keeping a Max count

like

Help! Excel won’t let me navigate using my keys anymore, arrow keys and enter will not move me to the next box. This is happening on multiple docs. Please explain how to fix this as if you’re talking to someone who is excel dumb (because you are).

like

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

like

Can somebody help me with the IF formula here please? I want to match Column K and Column O with No as the select values. I’ve tried =IF(K6=O6=“No”, ”match”) but it didn’t work. Thanks in advance for your help!

I'm trying to analyze some data on Excel. I have no idea what these column headers mean: SI GREV, GTN P/SI GREV, ST BMC GP

Any ideas?

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Need to count attendance per office location. Looking for cell formula that gives me live view of “yes” (attendance) when attendee is assigned to “x” office. Keep trying IFS but getting 0.

I have a date I need to match to an array of strings (that represents dates). Eg matching 6 nov 20 to (20201106, 20201107, etc. ). I can convert my date into this format using text(date,”yyyymmdd”) but then my lookup tried to match “20201106” with that list and the “ causes a mismatch. Any hints, and I would prefer not to change the array format?

like

Anyone work on a Mac and use parallels when in need of excel? If so, does it work or is it a big no-no? My work going forward will not primarily be excel, but I have to use it on weekly/monthly basis. Might also have to use some Power BI. Would love to go back to working on a Mac but excel has stopped me from buying one…

like

Opened a spreadsheet where the user did that thing where all of the rows and columns outside of a select area are grayed out so that you can't see or do anything wirh those cells. How to un-do this and make it normal?

like

Hoping someone here can help. I have two excel files, each with multiple worksheets, because they have different audiences. Management wants me to combine into a single workbook. Is there some way to restrict who can see which worksheet in this new file? Every user will fall into one of two groups. Alternative suggestions welcome!

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

Scan your QR code to download
Fishbowl app on your mobile

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