Hello,
I am trying to setup a contact list sheet. I can format all the other cells the way I like, but when I try to format the phone number column with format cells\special\phone number numbers are being displayed as (for the phone number (123) 123-1234 entered as 1231231234) : (1) 231-2312. For another real world example this phone number (602) 256-6700 entered as 6022566700 is being displayed as (6) 022-5667. Other phone numbers are having there last 4 digits rounded. I.E. 4554 is becoming 46.
I have no idea what has gone wrong! I have tried opening a new workbook, re-starting excel etc...
Thanks 1 millions times for any help.
-Todd
okay, I decided to skip that and went on to some other stuff. Now 2400 is being displayed as 24 no matter what I do or where I put it, even in a new workbook.
Bookmarks