View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jmc8355 jmc8355 is offline
external usenet poster
 
Posts: 2
Default Textbox Formatting

I have a userform with a textbox where the user needs to enter a number. When
the form is submitted that data goes to a specific cell in a worksheet. But
the number goes into the cell as text. How do I get it to go into the cell as
a number. I have tried to format the cell in the worksheet but it changes
back to text everytime. Thanks in advance for any help.