LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,651
Default How to format numbers as architectural fractions (1/16,1/8,1/4 )

On Tue, 16 Feb 2010 10:56:44 +1100, "macropod"
wrote:

My understanding is that the input value was already in a decimal value equivalent to 16ths (of an inch, presumably), in which case
the formatting is sufficient.


Obviously, I did not make that assumption. Certainly would make things
simpler.
--ron


 
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 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 04:20 PM.

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

About Us

"It's about Microsoft Excel"