Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
webquery loses format of leading zero and to scientific
Hi, the
I pull data from a web page using excel web query. The data have date, number and text. The problems are 1. The codes such as 01, 02 lose the leading zeros in excel 2. The large numbers such as 358762088221 was converted into scientific as 3.58E+12. I need the original format becasues it is account number. I tried every setting in webquery and can't figure out. Help is appreciated. Thanks Glen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
web query loses format of leading zero and to scientific
Any body can help?
"Glen: Webquery format" wrote: Hi, the I pull data from a web page using excel web query. The data have date, number and text. The problems are 1. The codes such as 01, 02 lose the leading zeros in excel 2. The large numbers such as 358762088221 was converted into scientific as 3.58E+12. I need the original format becasues it is account number. I tried every setting in webquery and can't figure out. Help is appreciated. Thanks Glen |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
web query loses format of leading zero and to scientific
Hi Glen
When you find out let me know I have a similar problem no body seems to know I will check your thread Thanks bill gras "Glen: Webquery format" wrote: Any body can help? "Glen: Webquery format" wrote: Hi, the I pull data from a web page using excel web query. The data have date, number and text. The problems are 1. The codes such as 01, 02 lose the leading zeros in excel 2. The large numbers such as 358762088221 was converted into scientific as 3.58E+12. I need the original format becasues it is account number. I tried every setting in webquery and can't figure out. Help is appreciated. Thanks Glen |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
web query loses format of leading zero and to scientific
try to format (before unloading from webpage) the column in which these
numbers will be downloaded into <text format and then download from web. is this of any help when you download codes which are numbers excel takes them as numbers and format them as numbers. =============================== bill gras wrote in message ... Hi Glen When you find out let me know I have a similar problem no body seems to know I will check your thread Thanks bill gras "Glen: Webquery format" wrote: Any body can help? "Glen: Webquery format" wrote: Hi, the I pull data from a web page using excel web query. The data have date, number and text. The problems are 1. The codes such as 01, 02 lose the leading zeros in excel 2. The large numbers such as 358762088221 was converted into scientific as 3.58E+12. I need the original format becasues it is account number. I tried every setting in webquery and can't figure out. Help is appreciated. Thanks Glen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop scientific format | Excel Discussion (Misc queries) | |||
6E+02 what is this ugly scientific format? | Excel Programming |