Thread: fractions
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Satti Charvak[_2_] Satti Charvak[_2_] is offline
external usenet poster
 
Posts: 53
Default fractions

format the cell directly with:

# ??/??

--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"knowalittleaboutthis" wrote:

I am trying to make a fraction out of a decimal. I need to round up the
decimal to the nearest 1/8" exanple .251 should come out to be 3/8" any
suggestions