How to Add Plus Sign (+) Before Positive Number in Excel (Easy Custom Formatting Trick)
HTML-код
- Опубликовано: 20 авг 2024
- 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...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoff...
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com...
✅ Free Dashboard Course - bit.ly/free-ex...
✅ Free VBA course - bit.ly/excel-v...
✅ Free Power Query Course - bit.ly/power-q...
✅ Best Excel Books: trumpexcel.com...
Subscribe to get awesome Excel Tips every week: www.youtube.co...
#Excel #ExcelTips #ExcelTutorial
Dude I've never paid attention to hat custom section of formatting. Now I'm using it every time I can.
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.
You never fail in bringing the actual to the public. Thanks brother.
This saved my life. Thank you so much.
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
Excellent excel tips. I have been thinking about this for long and never figured that out. Thanks so much
you saved much time
Superb. THanks it worked for me.
Glad you found the video helpful 🙂
Excellent.you are master of excel
Really useful number formatting video. Thanks Paul
You're a legend, greetings from the Netherlands
Thank you Sumit Sir...I have recommended your channel to many friends!...Great Job!
You are the BEST! Thank you
Thanks bro! Very helpful👍🏼👍🏼👍🏼
This is amazing! Thanks for the tip. Helps IMMENSELY for my line of work!
Excellent excel tips. Thank you Sumit
thank you very much - so simple, but to figure it out by myself was ...painful.
Thank you so much ! :)
This bloke is just so good
Thanks for commenting Deen... Glad you found the video useful!
Very useful information
This is better than Chat GPT
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. 🙏🙏☺☺
Brilliant- thank you very much
Glad you found the video useful!
@@trumpexcel looking forward to exploring your channel thanks again from the UK. The internet brings people together teaching and learning as one
Sumit Sir,
Thanks ! I am your regular viewer. ; )
Thank you very much!
*_You are the man! Thanks!_*
that was so smooth and easy. thanks man
Hi Sumit.. great video! Thanks for all the super tips and tricks using Custom Number Formatting.. very useful :)) Thumbs up!!
Super video and explanation. Helped me straight awway.
Thank u so much
He explained it very clearly. Love it thank you so much.
Bro you are a life saver, this exactly what I am looking for
It works extremely well. Thank you very much. If only I can give you 2 likes.
Thanks, I used that to help with my Excel DnD stat sheet.
Amazing tutorial. Thank you Sumit
Thanks Nader... Glad you found it useful!
Thank you!
Heartiest Thanks
Thanks, I was struggling with it.
Happy to know the video helped 🙂
Thank you so much bro......
Thnaks Sumit, very useful and simple!!
Very good tutorials. Very well explained. Thank you
Highly useful video. Thanks for such videos..
I really like the way you explained it, thank you
Thank you so much
THANK YOU
thank you!
Nicely explained Thanks 👌👍
thank you you did it
AMAZING APPLICATION EXCEL VBA
thank you for this tutorial! you are awesome!!!
thanks for the help
Thanks a lot bro... ❤😍
Great job, dear
It's a cool Buddy)))))))))))))))))
Thank you So much
THANK U BRO
Thank you so very much I really appreciate your help with this!
Very nice.... you save my day!
Glad you found the tutorial useful!
Smart and Useful !
Thank you!
Thank you
very useful many thanks you are very kind.
Awesome video, you always provide interesting contain
Excellent information Bro
Thanks
Super.. well explained 👏
Super.................
Good content. Keep up...
Thanks!
Glad you found the video useful!
Great
Thanks Sumit👍
Very informative
thank you
Thanks a lot for great trick as always.
Thank you Boss,
Very interesting, Thanks.
I like your video. 💪
thanks sir
Very helpful
Excillent sumit sir👏👏
Wonderful video. These Indians are good. The only problem is when you guys start speaking Hindi. I don't understand that lol
Nice video..
It's a cool tip. Thanks
Great,
You always give good contain.
Thank you! Cheers!
informative
Super
nice sumit
Thanks.
Thanks alot
Most welcome
Nice
Brilliant
Please have a tutorial non dependent drop down or some nice visual way to represent data.
more than great
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
You showed us for india, how about country codes like +91,+972 and their indiviual mobile or landline numbers. Tht will help a lot of ppl
I want to add # number before type number plz make video on this
Can we use the country code method in csv file.
+0 is not working in my excel 2007 before the contact number what should i do ?
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???
But I save the file. Open it back up. And the + sign is gone when I open it back up. What's going on?
I followed this same tip and nothing happened. The number does not change and no prefix was added. Please anyone with idea what could be wrong?
but how do you add a comma separator for larger numbers though?
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.