P
performancepart
Dear XLRS,
I am trying to do something that may be impossible. I am using a we
query to grab a list of Hyperlinks which point to specific models in m
warehouse. An example of a Hyperlink I would like to pull from th
website is: _0299921_
When I web query this page into Excel, the Hyperlink will show up a
_299921_, as you can see the leading 0 is gone. I am unable to grab th
model number from the Hyperlink address, so that is not an option
neither is formatting the cell to Text, as this will cause al
hyperlinks to be ignored!
Does anyone know how to prevent Web Query, or Excel itself from cuttin
off these leading 0's? I find this "feature" VERY annoying, I figure i
you put a 0 infront of another number YOU WANT THAT 0!
Thanks for your help
I am trying to do something that may be impossible. I am using a we
query to grab a list of Hyperlinks which point to specific models in m
warehouse. An example of a Hyperlink I would like to pull from th
website is: _0299921_
When I web query this page into Excel, the Hyperlink will show up a
_299921_, as you can see the leading 0 is gone. I am unable to grab th
model number from the Hyperlink address, so that is not an option
neither is formatting the cell to Text, as this will cause al
hyperlinks to be ignored!
Does anyone know how to prevent Web Query, or Excel itself from cuttin
off these leading 0's? I find this "feature" VERY annoying, I figure i
you put a 0 infront of another number YOU WANT THAT 0!
Thanks for your help