How to Add Plus Sign (+) Before Positive Number in Excel (Easy Custom Formatting Trick)

preview_player
Показать описание
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.

#Excel #ExcelTips #ExcelTutorial
Рекомендации по теме
Комментарии
Автор

Dude I've never paid attention to hat custom section of formatting. Now I'm using it every time I can.

chubbydawme
Автор

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.

kerklaan
Автор

This saved my life. Thank you so much.

aquilafarrell
Автор

Excellent excel tips. I have been thinking about this for long and never figured that out. Thanks so much

samuelmeende
Автор

This is exactly what I needed, thank you

tusharjaiswal
Автор

You never fail in bringing the actual to the public. Thanks brother.

theenglishproject
Автор

Thank you Sumit Sir...I have recommended your channel to many friends!...Great Job!

AshokYadav-ymrr
Автор

You're a legend, greetings from the Netherlands

twisterrrrr
Автор

Really useful number formatting video. Thanks Paul

PaulEBrownbill
Автор

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

xxxx-eyrp
Автор

that was so smooth and easy. thanks man

StevenLee-nnsn
Автор

This is amazing! Thanks for the tip. Helps IMMENSELY for my line of work!

coresnap
Автор

Super video and explanation. Helped me straight awway.

keeloraz
Автор

Hi Sumit.. great video! Thanks for all the super tips and tricks using Custom Number Formatting.. very useful :)) Thumbs up!!

wayneedmondson
Автор

Thnaks Sumit, very useful and simple!!

fernandocaceres
Автор

Highly useful video. Thanks for such videos..

ram-it.damn-it
Автор

thank you very much - so simple, but to figure it out by myself was ...painful.
Thank you so much ! :)

aleksandard.
Автор

Very good tutorials. Very well explained. Thank you

lambportuza
Автор

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. 🙏🙏☺☺

aashuroy
Автор

Sumit Sir,
Thanks ! I am your regular viewer. ; )

puneetvij