Posted to microsoft.public.excel.misc

Ian Elliott Ian Elliott is offline

external usenet poster

Posts: 46

how display 12/3 as fraction?

Thanks in advance for any help.
I tried to display 12/3 as "12/3" in a cell by formating as fraction, with
up to 2 digits, but it just shows 4.
Any ideas on how to show as 12/3?
Thanks

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
Display feet inches and fraction	Homer	Excel Discussion (Misc queries)	12	March 3rd 21 04:18 PM
Text fraction to fraction format	brownti via OfficeKB.com	Excel Worksheet Functions	1	February 1st 08 02:38 PM
How do I change fraction to fraction characters?	cmcqueary2806	Excel Worksheet Functions	1	November 2nd 06 09:58 PM
fraction	b166er	Excel Worksheet Functions	5	August 3rd 06 06:30 PM
Display ONLY fraction portion of number	John F	Excel Discussion (Misc queries)	4	January 6th 05 03:49 PM

All times are GMT +1. The time now is 10:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us