How do you get a zero to show up in front of a number if the numbers in the column are all different sizes, such as bank account numbers?
Adding apostrophe (
You can simply put an apostrophe (
') in front of the number, it will be formatted as text.
For example, input
'0012345 will display
Format at text
You can also format the cells as text, so that all leading zeros can be displayed without needing to add apostrophe (
') every time.
It is recommended to format bank account number as text instead of number. Because Excel stores only 15 significant digits in a number. The 16th digit will be lost for credit card number or if the bank account number is too long.