Change and edit numbers in column with macro.

Hi. I have below test sheet with numbers in Sheet 3 column D. They are pasted in from another application. I have tried solve this some time. But seems to be hard to make perfect.
I need first to get the minus on the right side to the left side, with the numbers with minus.
After that I need to change the format to number with dot as 1000 separator and comma. Now its the other way around and the format is general.
I have tried many codes but it seems not so easy.
Please take the time and have a look at the test sheet below. And see if you can help with this. I need a macro for it because its part of other sorting.

Thanks in advance

Sincerely
Abjac

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Hi John and thanks allot. I have tested it and its still not there. Many of the special minus numbers are in general format. And it cut the 2 zeroes after the comma.
I need it to be correct because I need to be able to sort it after according to value.
Please try with the sheet I uploaded. Paste the column D in to E so you can compare after.

I have had and tried many solutions but so far no luck.

If time please try with the test sheet here.

Sincerely
Abjac

HI Arkadi. I checked you macro and it first seems that it was great. But when I checked the format its in text.
I have a problem I need to sort this after and I don't know why it don't display the correct result- Please try use ur macro and after sort column D. It don't sort it correct I think please have a look at that and what can be the reason. I would mean it should give me the higest minus amount first and down to the lowest minus amount after that the lowest plus amount and up. But its mixed.

Please have a look and try in the sheet if you have time.

Thanks in advance
Sincerely
Abjac

Abjac - To change your decimal and thousands separators - Tools>Options>International>Uncheck use system separators and then edit the boxes.

HI Arkadi. 5 Stars for this macro. I dont need to go back to system settings in fact, son in this case it dont mind. But i shall use it also at my work laptop, so if you have the code to get it back it would be great of course, then i can save it if i need to roll it back.
But so far this code is brilliant really. I will wait to make this solved until you maybe can get the extended code to get it back again.,

But so far really really great. Let me know if you have the extended one.

Sincerely
Abjac