Forum Discussion
Formatting in Excel
I am trying to format a cell so the output looks like C23-569-789 when the following is entered into the cell c23569789. I can't seem to get it to work because of the leading Alpha. Help.
I am really surprised it is a NO.
You may use VBA to transform the text and return result into the same cell