Thread: number formats
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default number formats

Is this any good for you

0 ?#/32

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"blackbox" <u20390@uwe wrote in message news:5e2a7c20047ff@uwe...
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.