how do I show measurements as fractions

[lew]

how do I show measurements in inches with fractions, ie: 21 3/4" not 1' 9
3/4" when using measurement lines

 

[Chris Roth [ Visio MVP ]]

- Go to the ShapeSheet for your dimension line shape. Ie: Window > Show
ShapeSheet.
- Find the cell: User.FeetInch
- Paste this formula in the cell:

=IF(User.LUnitsInd=1,FORMAT(User.Feet*12+User.Inch,IF(User.Inch<1
in,"0/#"&User.InchPrec&"\""","0 #/#"&User.InchPrec&"\""")),0)

This will kill off the showing of Feet when you show Feet-Inches in the
right-click-menu options, but you'll get what you want. The rest of the
dimensioning features should remain in tact as well.



--

Hope this helps,

Chris Roth
Visio MVP

 

[lew]

Thanks Chris, I tried to input the formula but it showed "error in formula".
I might have made a typo since I couldn't paste in field. I am going on
vacation Monday for a week. I'll try to work on the weekend or when I get
back. By the way, you need to select a shape in order to see ALL the info on
shape sheet.
Thanks again for your help.
Lew

 

[Rob]

Chris,

This fix is very helpful.

It appears that you have to edit each individual dimension line. Is there a
way to apply this change globaly? Better yet is there any way to make this
change a standard precision choice from the pull down menu?

 

[lew]

Hi Chris, Could not find the cell: User.FeetInch. But I did find
User-defined Cells with fields for User.LPrec, User.LUnits and
User.ShowUnits. When I paste your formula in formula field and try to save it
says error in formula.
I saw the comment from Rob. Apparently he knows where to paste formula, but
it doesn't give the result I want. I can go in and edit each dimension but
when you do that the actual dimension does not change when you change the
size. This means you have to retype which leaves room for error and takes
away scale results.
Any comments?

 

[lew]

Hi Rob,
I see that you say this fix is very helpful. Can you show me where?
I am looking for the same results you asked about. If you change individual
dimensions you no longer show scale in your drawing.
What do you think?

Lew

 

[lew]

Chris, Something I noticed that we haven't pointed out. When you go into page
setup, page properties and then measurement units it has Inches and Inches
(decimal). I don't get any different display with each setting. But like I've
said, I get inches as decimals.
What do you think?
Lew

 

[John Marshall, MVP]

Watch the ruler and grid pattern when you switch between Inches and
Inches(decimal) in Page Setup. The first is based on 1/2,1/4,1/8,1/16 the
second is based on .1, .01, .001

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm