#### Bluemegaman

##### New Member

- Joined
- Nov 17, 2005

- Messages
- 7

Having problems with changing the format of some numbers (they're supposed to be telephone numbers!). when exporting into a spreadsheet from our database some of the telephone numbers (but not all!) miss their first zero so in excel they come out in one number like

208XXXXXXX

I Need them like this

020 xxxx xxxx

I have thousands of numbers with this problem. Am in need of some code which will add the zero to the front end of the numbers and then put a space after the third and seventh digit, otherwise excel just deletes the zero again .

I have tried using the Left function etc but am not very familiar with these as i only started vba last week.

Any help would be very appreciated.

Thanks -

Mike