Hi Trevor. Have you tried my suggestion? I tried it on a dummy sheet and it worked for me. The advantage to using a Worksheet_Change event is that you don't have to keep running the macro each time. The data is converted automatically after you enter it.