But that only works if the fraction has a single digit on top and on the bottom. It will fall down for something like 15/16.Waterhead37":3jnnz7vz said:GILL,
Had coffee - answer is - assuming you had 2/7 as text in say cell A5 :-
Too true. I was starting with a new sheet and didn't know what Gill was doing. Of course, Excel being ever helpful will keep 400/456 as a fraction even if it is not formatted as text, it's only if it thinks you are trying to enter a date that it will convert it. I do think that some of these programs can be too clever for their own good.LyNx":2vjhqwk6 said:not it you format the complete column or cells to be fractions.
then you can have 400/546 if you wanted
Now after my first coffee of the day and a bit of further reading...LyNx":1ouccg5u said:how would the equations above handle 3 3/16 into decimal.
Sorry Andy, should have read your post a bit better. For some reason I thought you were talking about formatting a cell as Text which is what I had been doing to avoid conversion to a date. Looks like you were already one step ahead of me.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. :?