Custom Number Display

[Lee Harris]

How can I get values to display in fractional form (only need accuracy to
0.5) while still being able to calculate with the values (or do I need a
separate column with a funky text format?)

 

[Gord Dibben]

Lee

Have you looked at Format>Cells>Number>Fractions?

Various options there including halves which is the accuracy you specify.


Gord Dibben Excel MVP

 

[Lee Harris]

Lee

Have you looked at Format>Cells>Number>Fractions?

Various options there including halves which is the accuracy you specify.


Gord Dibben Excel MVP

doh!