Forum Discussion
Leading zeros
It appears that there might have been an update that does not allow us to keep our leading zeros no matter what type of formatting we try. It was working perfectly until a day ago. Does anyone know if there was a Microsoft update that created this issue or if there is another work around?
1 Reply
- NikolinoDEGold Contributor
There are several possible ways to fix this issue:
You can use a custom format to keep the leading zeros.
For example, if you want to have four digits with leading zeros,
you can type 0000 in the Format Cells dialog box under Custom category.
You can use a text format to keep the leading zeros.
For example, you can type an apostrophe (') before the number, such as '0012,
or change the format of the cells to Text before entering the numbers.
You can use Power Query to keep the leading zeros.
This is a feature that allows you to import and transform data from various sources.
You can use it to add a column with a formula that preserves the leading zeros.
I hope this helps.