Author Topic: Problem with Display Values  (Read 2191 times)

0 Members and 1 Guest are viewing this topic.

dmyers

  • Jr. Member
  • **
  • Posts: 13
Problem with Display Values
« on: January 13, 2010, 06:23:50 PM »
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

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3833
  • Ideas Visio-lized into solutions
Re: Problem with Display Values
« Reply #1 on: January 13, 2010, 08:50:27 PM »
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
« Last Edit: January 13, 2010, 09:01:58 PM by wapperdude »
Visio 2019 Pro

dmyers

  • Jr. Member
  • **
  • Posts: 13
Re: Problem with Display Values
« Reply #2 on: January 14, 2010, 09:05:35 AM »
Thanks for the reply.  I just tried out the FORMAT command and it is giving me the result I was looking for.

Thanks