Format text issue

Hello everyone. The Thank you in advance for you help.

The attached workbook contains my seemingly simple problem.

I have data that needs to be formatted in a certain way in order to upload it into a finacial system. It needs to be in text (column B). The problem I'm running into is that I can't seem to format it or get a formula that will work that will return the values in Column B. The only way I can get that is to type it in manually. With thousands of lines per entry this is not an option.

Does anyone know a formula or format trick that I could use? This seems so simple but I can't find the answer.

Thanks

Eddie