Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 96
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding time in 24 hour format to produce hours in decimal format Hercdriver Excel Worksheet Functions 11 December 29th 09 02:06 AM
Need help with converting CUSTOM format/TEXT format to DATE format Deo Cleto Excel Worksheet Functions 6 June 2nd 09 08:14 PM
Replace million-billion number format to lakhs-crores format Sumit Excel Discussion (Misc queries) 1 December 9th 05 04:58 PM
how to format excel format to text format with separator "|" in s. azlan New Users to Excel 1 January 31st 05 12:57 PM
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work No Name Excel Programming 0 May 3rd 04 12:22 PM


All times are GMT +1. The time now is 10:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"