Posted to microsoft.public.excel.misc

Jack W

external usenet poster

Posts: 1

How to format numbers as architectural fractions (1/16,1/8,1/4 )

How do I format a number to the 1/16ths, but display the answer as an
architectural fraction? Example: I want to display .25 as 1/4 rather than
4/16, but want to round to 1/16 precision.

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
HOW TO CREATE AN ARCHITECTURAL NUMBER FORMAT	donhoe	Excel Worksheet Functions	1	July 16th 08 09:27 PM
architectural fractions	Cyberbiker	Excel Discussion (Misc queries)	8	October 8th 07 02:43 PM
How can I add whole numbers to fractions?	aw	New Users to Excel	2	March 6th 07 02:36 PM
Format Cells - Architectural Dimensions	kleivakat	Excel Discussion (Misc queries)	3	October 14th 06 06:32 AM
Provide Excel format for architectural units: ft-inches-fractions	bltseattle	Excel Discussion (Misc queries)	0	August 9th 06 05:58 PM

All times are GMT +1. The time now is 11:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us