ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Web Query Formatting Issue... (https://www.excelbanter.com/excel-discussion-misc-queries/148302-web-query-formatting-issue.html)

Jambruins

Web Query Formatting Issue...
 
I have a web query that imports data and in column K that data it brings in
is supposed to be something like 6-4, 5-5, 8-2,... When it brings it in
though it is converting it to a date. I have tried to format the column but
it just changes it to a 5 digit number (i.e. 5-5 goes to 39207). How can I
get it to bring in the text 5-5? Thanks.


All times are GMT +1. The time now is 11:10 PM.

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