Phone number Cell Format like Excel phone number cell Format

JonEric Eubanks

I can not for the life of me find where I can format cells for Phone numbers like excel. I'm having people enter in their info via a form and the phone numbers are causing immense discrepancies. Is there a way to format a column for phone numbers or selection on a form for phone number like there is for a date?

Paul Newcome

You should not "pre-fill" the formulas into rows. Getting the sheet started, you will need to insert a couple of rows with the formulas in them, but once there are two rows above the new entry that contain the formulas, auto-fill will pull the formulas down as new rows are submitted.

The form actually skips to the first row AFTER the last formula. It only appears that it is skipping to the last row because auto-fill is grabbing it.

Paul Newcome

There is not a built in format for it, but I recently helped someone with a similar solution. Let me dig through my notes and see if I can find the thread.

Paul Newcome

Take a look at THIS THREAD and see if maybe we can make this solution work for you.

JonEric Eubanks

Will this miss up the spreadsheet once a form inputs data from a user? I've notice if you place formulas in sheets where forms upload to they skip rows until the last row where the formula is located. Is there a way to prevent this? Right now I'm copying and pasting to excel to use their phone number cell format.

Paul Newcome

You should not "pre-fill" the formulas into rows. Getting the sheet started, you will need to insert a couple of rows with the formulas in them, but once there are two rows above the new entry that contain the formulas, auto-fill will pull the formulas down as new rows are submitted.

The form actually skips to the first row AFTER the last formula. It only appears that it is skipping to the last row because auto-fill is grabbing it.