User Form And Formatted Currency

[Guest]

I have made a data form for my excel invoice template it runs at the start up and when you enter the data into the form it transfers it to the cells I have specified, however I want the cells I have entered data to from my form specified as currency but when I highlight them and click currency so the next time it will be made currency I save the workbook and exit. I load the workbook up again and the data form pops up, I enter data into it and it is entered still as number I don't know what I'm doing please help!

 

[Arash_The_A_Level_Student]

Thanks alot I have a feeling this will help thank you for your time!