I have a large database of addresses that includes some postcodes and phone
numbers that begin with zero that excel unfortunately drops off. I have read
all the other posts on this topic but my problem is that i need the format to
remain as a number and not text as suggested by most due to problems
exporting the data into access, etc. I can solve the phone number problem by
simply putting spaces between the area code and the actual number for phone
numbers but this is of no use for the postcodes.

Is there a way to keep the zero's and maintain the number formatting?

Matt