Userform Number Format with Control Source

Friends - a simple problem has defeated me most of the day

My Userform1 contains a text box which inherits Data inputs from ControlSource. Control Source takes its input from Sheet1: A1
When the text box is linked to the control source cell, it ignores the format code in Sheet1;A1.
How can I specify the number format of a text box that is linked to a control source cell?

Example: TextBox22 inherits input from Sheet1: Cell A1 via Control Source. In this case Sheet1:A1 contains a percentage 5.03% (example)
I want the Textbox to display 5.03% when the userform opens.
I thought the following would do it..but it renders 5.03232545554544 etc...

Please Login or Register  to view this content.

Thanks Conor

nope.... I must be msiing something else

your line above is missing a closing ")" , but still doesn't work

sample file attached

great- got it. Thanks JieJenn- I owe you!