This weekend, lets get passionate 😉
Few days ago, Cheryl, one of our forum members asked this question:
How do you know Excel is your passion? Or is it?
I am searching for my passion, you know that thing that makes my heart sing. I mean I am listening for the pitter-patter in my ticker. So how do I know if Excel is it? Or anything for that matter. I am looking for that thing that will make me turn my tv off. (TV is my crack, I am truly addicted). I thought it was database development and honestly I am not altogether sure that it isn’t. Excel may be a substitute. A more attainable passion.
Give me some insight peeps. Some thoughts, musings, ideas.
As usual, many of our forum members chipped in with words of wisdom. Hopefully Cheryl saw their replies, if she ever managed to turn off that tv.
That gave me an idea for this week’s poll.
What are you passionate about?
My mother said to me, “If you become a soldier, you’ll be a general, if you become a monk you’ll end up as the pope.” Instead, I became a painter and wound up as Picasso.? – Pablo Picasso
Passion is an important force in our life. It is what makes us do mad, unreasonable, impossible & life-altering things. So, lets take a minute and examine what are we, as a community at Chandoo.org are passionate about.
I will go first
I am passionate about learning & sharing. That is why I quit my job to work full time on Chandoo.org. And Excel is the perfect vehicle to fulfill my passion. Everyday I wake up thinking ‘What I am going to learn today? How do I share this new knowledge with world? In what way I can help people become awesome in their work?’
Of course, I do not feel the same intensity of this passion everyday. Some days I learn a lot more than I can understand or remember. Some days, I just do not learn (or share) anything at all. But learning & sharing is what drives me every day.
Apart from this, I am also passionate about technology, traveling, legos, photography, books, design (of charts, dashboards & information displays), writing, walking, humor and living a simple & sustainable life.
Your turn…
Go ahead and tell us what you are passionate about? How do you fulfill this passion? If your passion relates to data analysis, visualization, automation or reporting, in what way Chandoo.org can help you?
Please share using comments.
11 Responses to “Fix Incorrect Percentages with this Paste-Special Trick”
I've just taught yesterday to a colleague of mine how to convert amounts in local currency into another by pasting special the ROE.
great thing to know !!!
Chandoo - this is such a great trick and helps save time. If you don't use this shortcut, you have to take can create a formula where =(ref cell /100), copy that all the way down, covert it to a percentage and then copy/paste values to the original column. This does it all much faster. Nice job!
I was just asking peers yesterday if anyone know if an easy way to do this, I've been editing each cell and adding a % manually vs setting the cell to Percentage for months and just finally reached my wits end. What perfect timing! Thanks, great tip!
If it's just appearance you care about, another alternative is to use this custom number format:
0"%"
By adding the percent sign in quotes, it gets treated as text and won't do what you warned about here: "You can not just format the cells to % format either, excel shows 23 as 2300% then."
Dear Jon S. You are the reason I love the internet. 3 year old comments making my life easier.
Thank you.
Here is a quicker protocol.
Enter 10000% into the extra cell, copy this cell, select the range you need to convert to percentages, and use paste special > divide. Since the Paste > All option is selected, it not only divides by 10000% (i.e. 100), it also applies the % format to the cells being pasted on.
@Martin: That is another very good use of Divide / Multiply operations.
@Tony, @Jody: Thank you 🙂
@Jon S: Good one...
@Jon... now why didnt I think of that.. Excellent
Thank You so much. it is really helped me.
Big help...Thanks
Thanks. That really saved me a lot of time!
Is Show Formulas is turned on in the Formula Ribbon, it will stay in decimal form until that is turned off. Drove me batty for an hour until I just figured it out.