View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Weaver Mike Weaver is offline
external usenet poster
 
Posts: 8
Default Format as fraction - why doesn't this work?

why doesn't this work?

format(1.5,"0 ??/??")

should return a string "1 1/2", it seems. Instead, it returns "2 ??/??"

What am I missing?

Thanks in advance