Hi there,
I'm looking to convert a column that is coming in as a formula text to a value so I want, 17/20 to come in as 0.85 (=17/20).
Now doing left() or mid() etc won't work as it could be 1/20, 18/5 etc.
I have tried =VALUE() and =EVALUTE(), but neither work.
Now the filed is in a date it will work so VALUE(19/10), will return 41566 (or 19/10/13). Which is fine, I have set up a decode for dates, so using a vlookup() on 41566 will return 1.9 etc.
But having no success in getting non-date fractions into values.
Any ideas?
Thanks.
Bookmarks