Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 5

Fractions

When converting a decimal to a fraction, I get some responses like 1/67 when
what I am looking for is increments of 1/64. Then I want to display 10/64 as
5/16 or 32/64 as 1/2 etc.
Can this be accomplished in an excel formula or combination of nested
formulas?

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
fractions	knowalittleaboutthis	Excel Worksheet Functions	3	November 18th 08 01:53 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
about fractions	patrick	Excel Discussion (Misc queries)	4	March 30th 06 03:27 AM

All times are GMT +1. The time now is 07:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us