How to add leading zeros to numbers in Excel. 🔢

Follow @exceldictionary for more tips and tricks. To learn all of Excel’s shortcuts and productivity hacks like this, check out my new course, ebooks, merch, and more linked below. 👇🏼

Just add apostrophe then continue typing

="00"&C5 also sufficient.

Typing in an apostrophe then using flash fill seems like an easier solution... less resource intensive too.

How to copy tables data from Gmail into #Excel please guide... I'm using MS Office Pro Plus 2013

@Adhavanathan very nice!

@SaveToNotion #thread #excel

👍

@grabvid

Excellent