View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
papou papou is offline
external usenet poster
 
Posts: 110
Default formatting text boxes

Hi Doug
Use format:
TextBox1.Value = Format(CInt(TextBox1.Value), "# ##0 $")
HTH
Cordially
Pascal

"doug" a écrit dans le message de news:
...
I have 3 text boxes on a form and a label that show the
sum of the 3. How do I format the text boxes and label so
it shows currency. If user enters 123 I want it to
display as $ 123.00 in the text box and in the label.
Thanks for your help