Lee

Have you looked at FormatCellsNumberFractions?

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


Gord Dibben Excel MVP

On Tue, 06 Dec 2005 00:35:21 GMT, "Lee Harris" wrote:

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?)