Quote:
Originally Posted by strongcoffee
I am hoping to shorten a very long winded manual entry of fractions by using cut and paste!
I would like to cut and past web based fractions write in the clasic method 1/2 6/4 extra with the next coulum then converting straight away.
Would welcome any help.
many thanks
Adrian
|
You could create a VLOOKUP table with the fraction in the first column and the decimal representations in the second and use that to convert.
And shouldn't "6/4" be "1 1/2"?