Hi everyone! I am really stumped here. I have a range of cells I am trying to format in phone # format. However, even after using the text to columns tool to ensure it isn't text and is in number format first, I have had no luck. I click on number > special > phone number in format cells menu. It even shows the number formatted correctly there. When I push OK nothing happens. Sheet and workbook is not locked. No idea!