Hello! I format a column in the spreadsheet ...

(Aparicio Piñeyrúa) #1

Hello!

I format a column in the spreadsheet side that allows me to give a “0” in front on the numbers. How can I do the same in appsheet side?

In my country if we need to call a mobile phone we dial “0” befor the mobile number, so I need to show that “0” in the appsheet side.

(Philip Garrett) #2

@Aparicio_Pineyrua1

If the column type is “Phone”, we automatically prefix the phone number value with a single quote when the phone number value starts with either zero (0) or plus (+).

The single quote preserves the leading zero. It also prevents the leading plus from

being treated as a worksheet formula.