Posted to microsoft.public.excel.worksheet.functions

Satti Charvak[_2_] Satti Charvak[_2_] is offline

external usenet poster

Posts: 53

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
looking for fractions	Rosa59	Excel Discussion (Misc queries)	3	October 7th 08 01:04 PM
fractions	smakee	Excel Discussion (Misc queries)	2	December 17th 07 05:24 PM
Fractions	Angel1	Excel Discussion (Misc queries)	4	October 18th 06 06:54 PM
Fractions	phil2006	Excel Discussion (Misc queries)	1	July 6th 06 11:36 AM
Fractions	Andy	Excel Discussion (Misc queries)	1	May 11th 06 05:02 PM

All times are GMT +1. The time now is 04:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us