Firstly, try asking the question in the body of the message rather than just
in the subject line.
Secondly, have you looked at Format/ Cells/ Fractions? [But that would just
change the display, so if you wanted to change the value you'd need the
"Precision as Display" option, which is dangerous if you forget that you've
applied it.]
A better option would be =MROUND(A1,0.125) or =MROUND(A1,0.25) [and you
could couple that with formatting as a fraction if you want it displayed
that way].
and format the cell as fraction with up to one digit
--ron
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.