Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default fractions

I have a spreedsheet that i need to get answers in the form of fractions in
1/8's, 1/4's, and 1/2's depending on which one. I all I can find is one or
the other not all is there any way to get the answer the way I want ie....
instead of 2/4 I need 1/2, and 1/4 instead of 2/8.

help please
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How do I stop fractions from being reduced? frustratedbyautocorrect Excel Discussion (Misc queries) 3 September 12th 06 07:02 PM
How to prevent Excel converting imported fractions into dates Phil A in the UK Excel Discussion (Misc queries) 6 March 28th 06 08:03 AM
fractions turn into dates when pasting in excel 2003 Eddie Spaghetti Excel Discussion (Misc queries) 5 March 24th 05 03:07 PM
Fractions to Decimals problem nickravo Excel Discussion (Misc queries) 1 March 7th 05 10:34 AM
How do I import fractions without data being converted to dates? rproeber Excel Discussion (Misc queries) 1 December 6th 04 12:53 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"