Bluemegaman
New Member
- Joined
- Nov 17, 2005
- Messages
- 7
Hi all,
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
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