How to create an extra field in the profile module to only accept the numeric values?
Install CCK module. Enable the number module that comes with CCK module. Once you enable the module you can able to add integer field to the Profile Content type if you are using content_profile module to add fields to registration.

See the screenshow below that i just got to do it using CCK, Number, Content Profile module in Drupal 6.