MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formating userform textbox value to numeric

Posted by Skip Bisconer on June 15, 2001 7:46 AM

I am working on an investment research data base and use a userform to enter data into the table. My problem is that the numeric information gathered goes to the data base as text and I cannot seem to figure out how to get it to stay numeric. Any ideas will be appreciated.

Posted by g-man on June 15, 2001 8:06 AM


Have you checked the cell formatting on the destination cell(s)? They could be formatted as 'text' instead of 'general' or 'number'.