Posts by good2soft

good2soft · May 29th 2007

Re: Convert Fractional Odds To Decimals

ByTheCringe2 + filo65

Decimal conversion works fine.

Many thanks

good2soft · May 29th 2007

Re: Dates Convert To Numbers

Thanks for all the input. Must take timeout for an hour or so. Must go to the bank. Will respond to your suggestions upon my return.

good2soft · May 29th 2007

Re: Dates Convert To Numbers

Dave

Followed your instructions but still get the serial code for the date. I feel I'm likely to end up wasting your time. I apologise.

good2soft · May 29th 2007

Re: Dates Convert To Numbers

Dave

Just tried that and the date 07-Feb changed to 39120. Does that mean anything ?

good2soft · May 29th 2007

When exporting a set of historical sports results to Excel 2003 the numeric odds are converted to a date eg 7/2 changes to 07-Feb. Can this be prevented or adjusted to retain the original data.

Also if I may ask can the UK style odds be converted to a decimal style. Eg. 7/2 (UK) needs to be converted to 4.5 ( Decimal equivalent )

I trust this is clear as I feel out of my depth just posting this question.