format phone numbers

Copper Contributor

I am using the Custom format number option to get a phone number format, but when I enter just numbers, this is what I keep getting.  I have tried using the special phone formatting and the format painter, but nothing seems to be working.  I don't know why 

(8) 436-9640
2 Replies

@djmoyle And what if you widen the column?

Screenshot 2022-06-07 at 16.56.53.png

@Riny_van_Eekelen 

 

Thanks, but the issue seemed to be the general formatting of my numbers.  Once I took the decimal places out on the defaults, both methods worked