For a Limited Period!
Buy 2 ~ Free 1 pax OR Get 30% off for every pax on our scheduled classes
for the month of Nov, Dec 2021 and Jan, Feb, Mar, Apr 2022
Microsoft Excel - Power Query (M365, 2021-2010)
Microsoft Excel - Power Pivot (M365, 2021-2010)
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.