format phone numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-3476757%22%20slang%3D%22en-US%22%3Eformat%20phone%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3476757%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20the%20Custom%20format%20number%20option%20to%20get%20a%20phone%20number%20format%2C%20but%20when%20I%20enter%20just%20numbers%2C%20this%20is%20what%20I%20keep%20getting.%26nbsp%3B%20I%20have%20tried%20using%20the%20special%20phone%20formatting%20and%20the%20format%20painter%2C%20but%20nothing%20seems%20to%20be%20working.%26nbsp%3B%20I%20don't%20know%20why%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%2280%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2280%22%3E(8)%20436-9640%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3476757%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3477319%22%20slang%3D%22en-US%22%3ERe%3A%20format%20phone%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3477319%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1416361%22%20target%3D%22_blank%22%3E%40djmoyle%3C%2FA%3E%26nbsp%3BAnd%20what%20if%20you%20widen%20the%20column%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202022-06-07%20at%2016.56.53.png%22%20style%3D%22width%3A%20304px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-06-07%20at%2016.56.53.png%22%20style%3D%22width%3A%20304px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-06-07%20at%2016.56.53.png%22%20style%3D%22width%3A%20304px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F378203i698CAA06F581EE7C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-06-07%20at%2016.56.53.png%22%20alt%3D%22Screenshot%202022-06-07%20at%2016.56.53.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3481701%22%20slang%3D%22en-US%22%3ERe%3A%20format%20phone%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3481701%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20but%20the%20issue%20seemed%20to%20be%20the%20general%20formatting%20of%20my%20numbers.%26nbsp%3B%20Once%20I%20took%20the%20decimal%20places%20out%20on%20the%20defaults%2C%20both%20methods%20worked%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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