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.... |
Format Numeric data in Textbox
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" wrote in message ... | 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.... |
All times are GMT +1. The time now is 07:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com