I am performing a web query to get some tabled information from our company
intranet into Excel. Some of the fields in the database on the intranet have
entries such as 000101. When the data arrives in Excel this comes across as
101 i.e. all leading zeros get 'lost'. I have set the format of the cells in
Excel to be text but still it doesn't work.

Any Ideas what I can do to make this work?