View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jambruins Jambruins is offline
external usenet poster
 
Posts: 65
Default 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.