Format Numeric data in Textbox

I have a text box that is linked to a cell that contains a currency value.
How can I format the textbox to reflect the proper format verses just a plain
text.

No matter how I format the linked cell the textbox always reflect a text
format. I see nothing in the properties to do this. Can I add some VB code
to format the data?

Thanks for any and all input....

If you don't mind changing the format of the value cell, then you can
just format it the way you want it to display in the text box - the
text box seems to reflect both the value AND the format of the linked
cell.
Rgds,
Scotto

"stickandrock" <stickandrock@discussions.microsoft.com> wrote in
message news:7F2C4390-1132-4513-8CD1-DFBEF2D551FF@microsoft.com...
| I have a text box that is linked to a cell that contains a currency
value.
| How can I format the textbox to reflect the proper format verses
just a plain
| text.
|
| No matter how I format the linked cell the textbox always reflect a
text
| format. I see nothing in the properties to do this. Can I add
some VB code
| to format the data?
|
| Thanks for any and all input....