Marcster
09-30-2005, 06:56 AM
Hi people :hi: ,
In column A I have numbers like:
300003
560046
402520
205740
203964
Which I need converting to:
30-00-03
56-00-46
40-25-20
20-57-40
20-39-64
How many items in column A will vary.
Can anyone tell me a VBA macro in which do this please?. :help
Also I need a macro
to save this file as a text file without any file extension. :help
i.e. Filename: 300905
Thanks,
Marcster.
In column A I have numbers like:
300003
560046
402520
205740
203964
Which I need converting to:
30-00-03
56-00-46
40-25-20
20-57-40
20-39-64
How many items in column A will vary.
Can anyone tell me a VBA macro in which do this please?. :help
Also I need a macro
to save this file as a text file without any file extension. :help
i.e. Filename: 300905
Thanks,
Marcster.