Excel, importing comma delimited files.

  pj123 16:59 08 Sep 05
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 05

Have you tried importing them in this format click here

  VoG II 17:31 08 Sep 05

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 05

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

  pj123 10:58 09 Sep 05

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.

Samsung Galaxy Book review: Hands-on with Samsung’s high-end hybrid

1995-2015: How technology has changed the world in 20 years

This is probably one of the best bank ads we’ve seen

Apple Watch 2 vs Huawei Watch 2 comparison review: watch out for 4G smartwatches Apple