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

Skip,

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


G-man