Leading Zeros

Ask for Help
1

Hi,
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.

2

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.

3

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