Textbox formatting conundrum

Hi ...

I am registering numbers into one of my sheets, by the use of a userform. This is unknown area to me.

From what I can deduct here, it must be like this; [that] the formatting of the textbox is for the text box and the textbox only, and do not even arrive the target cell. So ... by formatting the target cell as a number, one should expect that the problem was solved, but it's definitely not. It seems that the textbox is sending a textstring, that's it, and the target cell can't manage to reformat it to a number, resulting in numerals errors in the subsequent depending formulas.

Have anyone here, in this forum, experienced something like this?
And my be solved it? Perhaps? Uh?

Have you tried a variation of

Please Login or Register  to view this content.

Sorry, folks ...
But none of your suggestions worked so far...
Still the value of the textbox is transferred to the appropriate cell as a txt-string.

formatting the columns usually works for me.
formatting the output to the textbox then keeps the number viewed identical
as per attached userform

Try this

Please Login or Register  to view this content.

Well, what about that!?!?
My dear, Norie, you did it!
Your solution worked flawlessly!
Thanks a heap!!