Excel, importing comma delimited files.

  pj123 16:59 08 Sep 2005
Locked

Last year I used to import the fixed odds football coupon into Excel. No problem. This year doing the same thing, in excel I get, instead of, lets say 11/4 I get 11-Apr, 2/1 I get 2-Jan etc.. I have tried formatting the cells to "general" and "text" but then all I get is something like (instead of 11-Apr, 38483. and instead of 2-Jan, 38453. etc...

The author of the original files has suggested I change to Odds to Decimal not Fractions. Unfortunately, I can't deal with that, I am used to working in "old money". I know what 2/1 means but 1.65 means nothing to me.

Any help appreciated.

  VoG II 17:16 08 Sep 2005

Have you tried importing them in this format click here

  VoG II 17:31 08 Sep 2005

Actually, I've just tried this: at the appropriate screen you have to click on each column in the preview and tick Text.

click here

  pj123 17:44 08 Sep 2005

VoG™, that's exactly where I get them from. Just now got the latest files this very minute.

  pj123 10:58 09 Sep 2005

Thanks, VoG™. Although I don't recall having to change each column separately before. At least it is importing in to Excel OK now.

Ticked.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone