Doing some work at the moment and wondering if one of you lovely lot would be able to save me some time.
I have an excel workbook that contains account numbers in it. I need to slightly change their format so that I can use them on a template to upload into my accounting package at work.
Currently they look like this:
380200185040000
but I need them to look like this:
38020-0185040-000
I have about 20 sheets with an assload of accounts on each. Is there a macro or something I could run to insert the -'s?
The formulas I'm using at the moment involve me creating 3 extra columns and it's driving me nuts the amount of time it's taking.
Cheers
I have an excel workbook that contains account numbers in it. I need to slightly change their format so that I can use them on a template to upload into my accounting package at work.
Currently they look like this:
380200185040000
but I need them to look like this:
38020-0185040-000
I have about 20 sheets with an assload of accounts on each. Is there a macro or something I could run to insert the -'s?
The formulas I'm using at the moment involve me creating 3 extra columns and it's driving me nuts the amount of time it's taking.
Cheers
I swear I learn something new about excel every time I use it.