How to Add Plus Sign (+) Before Positive Number in Excel (Easy Custom Formatting Trick)
In this video, I will show you how to easily add a plus sign (+) before positive numbers in Excel.
By default, when you add a plus sign before a number, Excel would remove it (as it considers it redundant). But in some cases, you may actually need the plus sign - for example, when you're entering numbers with country code.
This can easily be done using a simple conditional formatting trick.
You can read more about this here: trumpexcel.com/add-plus-sign-...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzread.info...
#Excel #ExcelTips #ExcelTutorial
Пікірлер: 144
Really useful number formatting video. Thanks Paul
Dude I've never paid attention to hat custom section of formatting. Now I'm using it every time I can.
@trumpexcel
3 жыл бұрын
Thanks for commenting Michael... Glad you found the video useful!
No idea that something as simple and useful was possible. I don't think you can ever stop learning new things in Excel. Thank you.
Superb. THanks it worked for me.
@trumpexcel
4 ай бұрын
Glad you found the video helpful 🙂
You never fail in bringing the actual to the public. Thanks brother.
you saved much time
Excellent.you are master of excel
You are the BEST! Thank you
Thanks bro! Very helpful👍🏼👍🏼👍🏼
Excellent excel tips. I have been thinking about this for long and never figured that out. Thanks so much
This saved my life. Thank you so much.
I am in love with your video and way of teaching. Unlike other you shared all the knowledge regarding that topic with lots of example, specially starting from basic to advance. I have watched your 12hr Complete excel course (26 lesson) . Having a non it background (Mech engineer) you really made it simple. Except Dynamic charting I understood everything 😊. A big round of applause frm my side. Thank you so much for such a amazing videos. One day you will shine . True teacher can win the heart and you proved it. 🙏🙏☺☺
Thank you Sumit Sir...I have recommended your channel to many friends!...Great Job!
He explained it very clearly. Love it thank you so much.
Smart and Useful ! Thank you!
This is amazing! Thanks for the tip. Helps IMMENSELY for my line of work!
Very useful information
You're a legend, greetings from the Netherlands
Thank you very much!
Excellent excel tips. Thank you Sumit
Hi Sumit.. great video! Thanks for all the super tips and tricks using Custom Number Formatting.. very useful :)) Thumbs up!!
Thnaks Sumit, very useful and simple!!
Very good tutorials. Very well explained. Thank you
Brilliant- thank you very much
@trumpexcel
3 жыл бұрын
Glad you found the video useful!
@Lufc-Chaddy
3 жыл бұрын
@@trumpexcel looking forward to exploring your channel thanks again from the UK. The internet brings people together teaching and learning as one
Thank u so much
Bro you are a life saver, this exactly what I am looking for
Amazing tutorial. Thank you Sumit
@trumpexcel
4 жыл бұрын
Thanks Nader... Glad you found it useful!
I really like the way you explained it, thank you
*_You are the man! Thanks!_*
Highly useful video. Thanks for such videos..
Super video and explanation. Helped me straight awway.
Thank you so much bro......
Sumit Sir, Thanks ! I am your regular viewer. ; )
Thank you!
thank you very much - so simple, but to figure it out by myself was ...painful. Thank you so much ! :)
Thanks a lot for great trick as always.
thank you for this tutorial! you are awesome!!!
Thanks, I was struggling with it.
@trumpexcel
5 ай бұрын
Happy to know the video helped 🙂
THANK YOU
Thank you so much
that was so smooth and easy. thanks man
Heartiest Thanks
thank you!
Awesome video, you always provide interesting contain
Nicely explained Thanks 👌👍
thanks for the help
Very interesting, Thanks.
Thank you so very much I really appreciate your help with this!
Thanks a lot bro... ❤😍
AMAZING APPLICATION EXCEL VBA
thank you you did it
very useful many thanks you are very kind.
It's a cool tip. Thanks
Bro i was struggling with this fir 12hours you really helped me with some short video😂😂 u almost need to know how to code before using excel
Thank you Boss,
Excellent information Bro
Thank you
Great job, dear
Great, You always give good contain.
@trumpexcel
4 жыл бұрын
Thank you! Cheers!
THANK U BRO
Super.. well explained 👏
Thanks Sumit👍
This is better than Chat GPT
Very informative
Thanks, I used that to help with my Excel DnD stat sheet.
Very nice.... you save my day!
@trumpexcel
4 жыл бұрын
Glad you found the tutorial useful!
It's a cool Buddy))))))))))))))))) Thank you So much
Excillent sumit sir👏👏
This bloke is just so good
@trumpexcel
3 жыл бұрын
Thanks for commenting Deen... Glad you found the video useful!
Good content. Keep up...
Thanks
Very helpful
Super.................
thank you
I like your video. 💪
Nice video..
Thanks!
@trumpexcel
3 жыл бұрын
Glad you found the video useful!
Thanks.
thanks sir
It works extremely well. Thank you very much. If only I can give you 2 likes.
Great
Thanks alot
@trumpexcel
4 жыл бұрын
Most welcome
nice sumit
Brilliant
more than great
Nice
informative
Super
Thank you Sumit, captivating and informative video as always ! Can I ask a question? I have a series of product numbers like 0158.234555, 0158.891323, 0158.331233, and so on. I want to be able to type just 234555 891323 331233 and use custom format like "0158." but it doesn't work, the "dot" is moved to the end and the "0" at the front disappear. How to get around this?
Please have a tutorial non dependent drop down or some nice visual way to represent data.
Cool
Hi sumit, I am stuck with one logic where i want make auto scheduling for checking tooling i have date of checking and rechecking but concer is that if in month there are 40 tools which i have to check in coming month ..so i need to do manually gantt chart week or date wise ,can you please help me out
Can we use the country code method in csv file.
What about costum format, with keeping zero number in back off three decimal point number. Ex 3,780, the zero on the back is usually cant show.
Thanks, great video, very helpful! But how can I still include the positive sign in the number but also specify that I want it to also be two decimal places? Currently, the format cells format box - as also shown in your video - it seems only allows you to select one specifying formatting clause at a time. so, I cannot have 2 decimal places while also keeping the positive sign as shown the way you have done it. Is there any solutions here? Thanks!
@ivanlai5467
Жыл бұрын
You can select the cells and then change the number of decimal places in the home tab
Sir, Is there anyway we can add type of phone number format to be displayed using Special category - Location -English (India). When selected English (India) the type box is empty.
but how do you add a comma separator for larger numbers though?
💞👌🏼
Hi..there.. tqvm for this nice teaching. I am from Malaysia, .my country code is +60, but i only able to add +6 in front my phone no. instead of +60.... pls help... tqvm, teaccher
how expect from + in front if the number in huge for example now in general shows the number 194,500 without the plush in front but when I do with the plush in front it shows +194500. How I make it to show +194,500???