12 Replies Latest reply on Feb 22, 2017 7:30 AM by David Li

    format 10 digit integer to phone number (i.e. 8005551212 into (800)555-1212)

    erin.barr

      I have a file that has phone numbers in an excel document.  They are typed in as 8005551212, but the Excel formatting allows me to see as (800) 555-1212.  Even thought it's formatted like that in Excel, it comes over to Tableau as 8005551212 (in some instances, i notice 800555-1212, not sure why this is?).  But in any event, how do I format as (800) 555-1212?  Any thoughts?