Web Query - no leading zeros HELP!
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? |
All times are GMT +1. The time now is 01:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com