Fractions show as dates
That will absolutely work- as long as you need it for screen display
purposes only. If you try to convert that back to a numeric value
using a formula such as =VALUE(A1) where the value in A1 is '1/2 Excel
converts it to a date again, and you're back to the original problem.
|