Text box - Accounting Format
 

Hi,
How can i have the text box to reflect the values in Accounting Format ?

Also
The accepted value from this text box needs to get stored on an excel table
in the SAME (ACCOUNTING) format. While I've done the cell formatting, for
some reason it does not store in the same format. I need to go manually &
click once in the cell & it then converts into the Acc format AUTOMATICALLY.

Ps : I dont seem to have a problem for another text box doing the same
function.
I've tried everything posssible. How can i get around this ?

Thx
Matts