Related Posts
Eid Mubarak Fam!!!
Anyone working in sustainability?
Which is good to join..Publicis sapient or LTI?
no one:
every tech manifesto:
Who can relate? 🥴😂
Does your boss know your SO/spouse?
Is there a major dip coming? Thoughts?
Additional Posts in Excel Genius
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Multiple by 1 through “Paste Special > Multiple” works for me and is pretty slick. No need to add columns in the data set.
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.)
Also see T() and N()
Text-to-Columns does the same and doesn’t require adding a column to make the formula/pasting as values, etc.