Problem with Display Values

Started by dmyers, January 13, 2010, 11:23:50 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

dmyers

I am trying to develop an equation within the Shapesheet that uses the Width property from another shape as an input, ie: "Sheet.279!Width / 5".  The problem I am having is that when I reference the Width of the other shape it adds a PT to the end of the number (ie: 12 PT. and what I want is 12).  Is there any way to tell Visio to remove the PT.?

Thanks

wapperdude

#1
Try using the format statement, http://msdn.microsoft.com/en-us/library/ms406694.aspx

For example, FORMAT(Sheet.279!Width / 5,"#.# ").  Actual example of using this may be found here:  Drawing Scale Symbol: a smartshape  (http://visguy.com/vgforum/index.php?topic=962.0)

HTH
Wapperdude
Visio 2019 Pro

dmyers

Thanks for the reply.  I just tried out the FORMAT command and it is giving me the result I was looking for.

Thanks