Had coffee - answer is - assuming you had 2/7 as text in say cell A5 :-
LyNx":2vjhqwk6 said:not it you format the complete column or cells to be fractions.
then you can have 400/546 if you wanted
LyNx":1ouccg5u said:how would the equations above handle 3 3/16 into decimal.
LyNx":i1gf62yz said:Andrew. Thats how i noted it at the start
Works fine, Andy - just leave a space between the whole number and the fractionLyNx":38ehaawr said:I was just wondering how it would work out for the long formula's if a whole number was added. :?