VBA macro to re-format data

[mturbin]

Hi all,

A simple VBA question.

I am using (or trying to) an excel macro to read temperatures from a file and output them in a new formatted file. The macro is;

Please Login or Register  to view this content.

I want;

^^^970.031
3000001
^^^934.616
3000002
^^^882.253
3000003
^^^560.491
3000004
^^^575.562
3000005

I get;

970.031
3000001
934.616
3000002
882.253
3000003
560.491
3000004
575.562
3000005

How do I modify the macro to give me what I require.

ie 3 spaces, temperature
0 spaces, point

Thanks for reading. All help gratefully received.

M

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[mturbin]

oops!! Sorry about that, Roy. I'll read the forum rules when I have time. Thanks for the advise.

M