Import Web Query Looses Number Format

I am wanting to use Excel to perform a web query into an online database our company uses. One of the columns I am wanting to import contains numbers that are 20 digits long & they begin with 4 zero's. The problem is that when Excel imports the query, if I fprmat the cells & preserve the formatting, it cuts off the first 4 zero's & replaces the last number with a zero. Basically, it looks as if it is only importing 15 numbers. Is there a way around this ; is there a way to force Excel to import all 20 numbers? If I don't format the cells, it imports in the following format - 4.20017E+15

Re: Web Query of numbers

Quote from alring

Hi Nashkat

I'm not sure want you want. But I think it's this you want.

Right click on the cells were you want to have thoose numbers and under Custom you wright 0000###############0

Try this.

Alring

Display More

What I am running into is this. When I query off the particular web based program, the output for the carton ID is 20 digits (for example, one would be 00004200170865987458). When I export this using Web Query, it only imports 15 digits - it cuts the first 4 zeros off & replaces the last number with a 0, no matter how I format the cells. If I do not format the cells prior to importing the info, it shows up as 4.20017E+15. So all in all, out of a 20 digit number, it only improts 15 of the 20. Is there a way to change this or am I destined to not use Web Query with this particular program?