Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming |