Convert Existing Number to Percentage in Excel without x100
How to convert an existing number to a percentage in Excel without multiplying that number by 100. Add % symbol to a column of numbers by formatting neighboring cells as percentage and then using a formula to divide the number by 100. Copy down and reformat your sheet as necessary. Format your numbers as a percent without x100.
Do you have an existing column of numbers in Excel that you need to represent as a percentage?
Like, we want this to be 2.2%, but when we click the % button to format the cell, it automatically multiplies the number by 100. Since that is not what we want, I'm going to click Undo.
Now, what we can do is preformat the cell next door as a percentage, then we can enter a formula to divide our existing number by 100 so =A2/100 and hit Enter.
Double-click the auto-fill to copy down, hit Ctrl+C to copy, then right-click, Paste Special…Values.
Move our header over, delete the other column, re-format…and call it done!
If you have another way of doing this, please share it with us in the Comments!!
Be sure to subscribe to my Channel for more helpful tips and tutorials.
I'm @SharonSmith Thanks for watching!
#msexcel, #exceltips, #exceltutorial
📺 Watch Next - • How To Calculate Employee Turnover Rate - ... Calculate Employee Turnover Rate in Excel
__________
CONNECT WITH ME 📎
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: / sharonsmithhr
Twitter: / sharonsmithhr
__________
GEAR
🎙 Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
🖱 Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!)
🎥 Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
📗 Green Screen: https://amzn.to/2DnHsY2
📸 Camera: https://amzn.to/39KvpQA
🔌 Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)
RESOURCES
✏️ JotForm: https://www.jotform.com/pricing/?utm_...
📑 Wondershare PDFelement (PDF Editor): https://bit.ly/31QEkA8
💻 PresenterMedia: https://shareasale.com/r.cfm?b=417324...
Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
TEMPLATES
Check out my helpful list of templates available for purchase: https://www.etsy.com/listing/87584666...
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: https://www.paypal.com/cgi-bin/webscr.... Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS
✦ Visit https://mailchi.mp/6a0859ea0844/sharo... to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
PLAYLISTS:
➤ Jotform Tutorials: • Jotform Tutorials
➤Creating Fillable Forms: • How To Create A Fillable Form In Microsoft...
➤PowerPoint Tutorials for HR: • PowerPoint Tutorials
➤ Excel Tutorials for HR: • Microsoft Excel Tutorials
➤ Excel Quickies (Around 2 Minutes): • Excel Tips & Tricks
➤ Word Tutorials for HR: • Microsoft Word Tutorials
➤ Welcome | About Me: • Playlist