![]() |
Format a txt box.
Users enter info in a text box; which is later displayed
in a second text box. One of the text boxes is for amounts. Currently, if they enter 10, that is how it is displayed in the second text box. Is there an easy way to ensure that amounts are always displayed with 2 decimal points in the second text box (10.00)? Thanks for the help |
Format a txt box.
Textbox2.text = format(cdbl(Textbox1.Text),"#0.00")
-- Regards, Tom Ogilvy "JT" wrote in message ... Users enter info in a text box; which is later displayed in a second text box. One of the text boxes is for amounts. Currently, if they enter 10, that is how it is displayed in the second text box. Is there an easy way to ensure that amounts are always displayed with 2 decimal points in the second text box (10.00)? Thanks for the help |
Format a txt box.
if hte text boxes are not linked and you are programming the value into the
second one then you can val1 = textbox1.text val2 = format(val1,"$0.00") textbox2.text = val2 "JT" wrote: Users enter info in a text box; which is later displayed in a second text box. One of the text boxes is for amounts. Currently, if they enter 10, that is how it is displayed in the second text box. Is there an easy way to ensure that amounts are always displayed with 2 decimal points in the second text box (10.00)? Thanks for the help |
All times are GMT +1. The time now is 05:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com