Format the cells as Text before entering the numbers
Type an apostrophe before the number, such as ‘0123
Use a custom number format with leading zeros, such as 0000
Use the TEXT function, such as =TEXT(A1,”0000″)
Use CONCAT or ampersand to add a zero, such as =”0″&A1