you will need to create a new formula text field
var text MyTel = ToText([Std Tel]); // insert your own Tel field here.
var text RemoveOneBracket = SearchAndReplace($MYTel,"(","");
SearchAndReplace($RemoveOneBracket, ") ","-")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com------------------------------
Original Message:
Sent: 09-01-2022 16:44
From: NOEL HODGES
Subject: Phone number to rich text formula format
Hi,
I need to change a phone number (555) 555-5555 to this format instead 555-555-5555 .
It seems quickbase default format is with () and Im not sure how to get rid of them.
------------------------------
NOEL HODGES
------------------------------