asked on June 10, 2015
I have many forms that look up to a SQl database. the info is imported from an excel spreadsheet. is there a way to format the cells to veiw properly, from the lookup.
EX. my spreadsheet has thier phone number as 9135555555 i would like it to pull and email out as (913) 555-5555
Ex2. I have a field that pulls in a dollar amount 500. the dollar fields in my form pulls in 500.0000
0
0