LinkedIn facebook


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.