When a user enters data in a spread sheet the spread sheet can be formatted so that (say) 36 appears as $36.00, or 25/3/9 appears as 25-Mar-09.

What I want to do is the same sort of thing in a User Form, so that when the user has entered a number and tabs to the next field the number looks like currency.

I have several label captions that take the user input and remove the tax to provide a nett value, or that add bank fees which I have been able to format. (This form sits in an excel file.)