Thread: number formats
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
blackbox via OfficeKB.com
 
Posts: n/a
Default number formats

Bob,

0 ?#/32 displays 13/32 instead of 12.5/32


Bob Phillips wrote:
Is this any good for you

0 ?#/32

How can I combine decimal and fraction number formats. example 12.5/32
I've been using 64ths but it's not the proper format for my application.
Under format cells number custom, I tried entering 00.0/32 but excel
won't accept it.


--
Message posted via http://www.officekb.com