Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
-------------------------------------------------------
Saturday, August 13, 2011
yogi_Reformat 10-Digit Phone Numbers In Form Responses Sheet For Uniformity
Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
-------------------------------------------------------
Subscribe to:
Post Comments (Atom)
THX!! This was even easier to use than the one I found last year. Great that it automatically applies to rows below without copying and pasting.
ReplyDeleteHi katbrain:
ReplyDeleteGlad to hear this works for you ... Now Let Us Keep Googling.
Cheers!
Yogi
worked for me like a charm just now on 4323315553 style numbers - to US phone format. Thanks!
ReplyDeleteHi Sean:
ReplyDeleteGreat ... Now Let Us Keep Googling.
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com
hi good day, is there a way to reject of input with same number?? e.g. user enters exactly the same number that was already on the Form Response.
ReplyDeleteHi kel_TekNix:
ReplyDeleteGreetings!
I will add a sheet to suppress duplicates phone numbers -- I will post the reference to the work with unique phone numbers when ready.
Make It A Great One
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com
How can i hold the form or validate while taking input if the entry is not 10 digits. The validation on cell haven't helped me?
ReplyDeleteWill be great ..