Format the cells as Text before entering the number
Type an apostrophe before the number, such as ‘0123
Use a custom number format like 0000 to display leading zeros
Use the TEXT function, for example =TEXT(A1,”0000″)
Use CONCAT or ampersand to add a zero, for example =”0″&A1
Use Flash Fill to create a pattern with leading zeros
Import data as text to preserve leading zeros
Apply a custom format with the exact number of digits you want to show