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.
Yes, you can't format the text such way
I am really surprised it is a NO.
You may use VBA to transform the text and return result into the same cell
do you have a suggestion on VBA?
Andrew, I'm not an expert in VBA. On the other hand if nobody else suggests the code I believe you may google for something similar, it shall be relatively simple code.