Quality, Affordable & Flexible
Take advantage of our Microsoft Office Series public courses’ Buy 2 Get 1 FREE package!!
Formatting - Number Formats
Let's say your numbers need to be 4 digits long. 1 to be shown as 0001, 2 as 0002 and so forth. Click Format/Cells/Number/Custom go to the type text box and type in 0000 & click ok. The advantage of this formatting is that you can still perform calculations as it is still a value and not a text.