Hello,
I have created a web query that imports/refreshes data from one of our internal website.
But eventhough I have set the format of all the cells in the spreadsheet to "text" it always shows some of the new items in scientific notation for values with E followed by number.
The formats in those cells have somehow changed to "scientific".
(When I do a paste special>values, it comes out okay!)
But I want to use the web query which is a lot easier.
Is there any way to stop or avoid this?
Appreciate any help.
Thanks a lot...
I have created a web query that imports/refreshes data from one of our internal website.
But eventhough I have set the format of all the cells in the spreadsheet to "text" it always shows some of the new items in scientific notation for values with E followed by number.
The formats in those cells have somehow changed to "scientific".
(When I do a paste special>values, it comes out okay!)
But I want to use the web query which is a lot easier.
Is there any way to stop or avoid this?
Appreciate any help.
Thanks a lot...