ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Webquery (https://www.excelbanter.com/excel-discussion-misc-queries/924-webquery.html)

Othello

Webquery
 
Hi all,

I have a question about Excel 2002. When I import a table from a
website using a webquery, I can disable date recognition but not time
recognition. This means, for example, that Excel will convert this

29:53

into this

1-1-1900 5:53:00

I would just like to import "29:53" as plain text. Can anyone tell me
how to do this?

Thanks a lot!
Othello


All times are GMT +1. The time now is 09:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com