View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default 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.