I've created a form (Excel 2003) and have textboxes to collect data.

Some data are numeric. Are there any controls that I can use that will
format numbers, percent, etc?

I've already written code to format, but it is cumbersome.