Hi

I have created a userform with several textbox's on. They pull in
infomaton form a cell on a spreadsheet and i then can edit them if i
wish to do so.

How can i format the text box's to show 2 decimal placings and
currency.

Many thanks in advance

Regards

Oggy

Use something like this:

me.textbox1.value = format(me.textbox1.value, "$###,##0.00")



Oggy wrote:
Hi

I have created a userform with several textbox's on. They pull in
infomaton form a cell on a spreadsheet and i then can edit them if i
wish to do so.

How can i format the text box's to show 2 decimal placings and
currency.

Many thanks in advance

Regards

Oggy

Thanks,

this is what i am looking for, but when i enter a number eg 2.72 it
rounds up to 3.

Do you have any suggestions.

Thanks again

Oggy


Oggy wrote:
Hi

I have created a userform with several textbox's on. They pull in
infomaton form a cell on a spreadsheet and i then can edit them if i
wish to do so.

How can i format the text box's to show 2 decimal placings and
currency.

Many thanks in advance

Regards

Oggy