Say I have 5.25 I want to read like 5 1/4. If it's 5.31 I want it to read 5 1/3. If it's 5.74, 5 3/4 etc...
Is there a way?
Say I have 5.25 I want to read like 5 1/4. If it's 5.31 I want it to read 5 1/3. If it's 5.74, 5 3/4 etc...
Is there a way?
Last edited by trickyricky; 12-11-2010 at 03:41 AM.
Right click on the cell with number
Format cells
Fraction
Up to one digit (1/4)
OK
Try
=INT(A1) + LOOKUP(MOD(A1,1), {0;3;7;10;14;17;21}/24, {0;3;4;6;8;9;12}/12)
... and format the result as # ?/?
Entia non sunt multiplicanda sine necessitate
shg you're a beast! thank you kindly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks