Webpage conversion

[cubbybear3]

I am importing a webpage via webquery (using: WebFormatting=None). My
problem is that some of the text values are in Exponential notation
(ie: 2E9, 0E7, etc). These values are actually text values (Airport
Identification codes) but get converted to numeric. How can I prevent
them from getting converted to numeric values? Thanks for any help.
-pb

 

[ShaneDevenshire]

Hi,

You didn't show us an example of the actual codes that are being imported so
if the numbers are less than 15 digit you can simply reformat the cells in
Excel to a Number format.

 

[cubbybear3]

I thought I did?!? On the webpage, the value is "2E9" but that gets
converted to "2.00E+09" (exponential notation) in my spreadsheet. And
likewise, "0E7" get converted to "0.00E+07".
-pb

 

[ShaneDevenshire]

Hi,

Sorry, I guess you did. I assumed you were telling us how they looked in
Excel.

If all the value are coming back in exactly this format one could use a
formula like this to handle it:

=LEFT(A1)&"E"&LEN(A1)-1

However, I suspect the the returned data is a lot more complicated. Is it
all in one column? Give us some more examples of what's being returned.
Stuff that isn't causing a problem for example. Because to develop a formula
solution I need to know all the possibilities.