Change format into a Europe Number Format and divide with 1000

HI.

I need to change format in some weird numbers(some with minus infront), from the format to european format. After to divide with 1000

Europe Number Format (from #,###.00 to #.###,00) and divide all by 1000

It give me really problems, part of some training. I some could have a look at below test sheet. I can use formula or vba or both would be good to have for the understanding. Or just instructions how to do. BUt try it please in the test sheet, it give me problems much.

Thanks in advance
Sincerely
Abjac

HI JieJenn and thanks It can be used for sure i put away the currency but its the result and its good.
I would prefer if it can be done in the same sheet with format but not sure that can be done ok.But if you know how that can be done it will be great for sure. Or with macro also.

Another option is a formula in the result sheet which diplay the value and not the formula, and then copy it back to sheet1.

Please see if that can be done if time. But your solution is correct, but will wait if it can be like upper if possible.

Thanks

SIncerely

Abjac

HI JieJenn. Thanks allot that works also perfect and for me a better solution. Thanks allot for your help. Have a nice evening.

Sincerely

Abjac