Home > Net >  Why is this Query statement not displaying "text" formatted phone numbers" on Google
Why is this Query statement not displaying "text" formatted phone numbers" on Google

Time:02-11

This formula is returning eveything right,but the phone numbers, which are preceded by an apostrophe. If I happen to delete the apostrophe, it displays the numbers, but since there may be a 0 at the beginning, it has to come as text.

Here's the formula:

=iferror(QUERY('Form Responses'!$A$4:$P; "select N, B, C, D, E, F, G, H, I, J, K, L, A where N >= 1 and todate(A)=date '"&TEXT(B3;"yyyy-mm-dd")&"' order by N Asc");"Pick a date")

Here's how the data looks: enter image description here

...and this is the result right now: enter image description here

Here's the link to an example: enter image description here

  • Related