formatting leading zeros

How can I format a cell so that leading zeros (such as in a postal code) are not “swallowed”?

1 Like

Hey @franjosfjh :wave:t4: thanks for reaching out. One of the ways I can think of is by converting the data to text. Perhaps with the help of our TO_TEXT function.

Something like so —

We still don’t have any advanced cell formatting options that would allow you to display leading 0s by default though :sweat_smile:

Hope this helps but do please feel free to write back in case there’s anything else we could do.