Custom Number Display
 

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

Custom Number Display
 

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

Custom Number Display
 

"Gord Dibben" <gorddibbATshawDOTca@ wrote in message
...
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?)


doh!
:-)