Waterhead37":3jnnz7vz said:GILL,
Had coffee - answer is - assuming you had 2/7 as text in say cell A5 :-
=MID(A5,1,1)/MID(A5,3,1)
if I type 2/7 into a cell it interprets it as 02-Jul.
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. :?
Enter your email address to join:
Register today and take advantage of membership benefits.
Enter your email address to join: