Leading Zeros

I did not find solution for leading zeros in the forum.

My use case, I need leading zeros to be accepted as they are because it is for mobile number.

What will be the best automated way? I know you can manually go in and put '0 infront. I have also formatted as plain text. But when new row is added, this plain text formatting is gone.

Suggestions please.

Do you need the column to be a number field inside Glide? If not, you can change the column type from number to text and it should respect the plain text formatting you set up in your sheet.


Have you tried using a phone entry and format your column as phone number?