« previous next »
Pages: [1]   Go Down

Author Topic: Can I specify a formula and a format string?  (Read 2977 times)

0 Members and 1 Guest are viewing this topic.

Jennifer

  • Hero Member
  • *****
  • Posts: 553
Can I specify a formula and a format string?
« on: November 14, 2011, 11:23:36 AM »
On a rectangle shape, I inserted a field to show the area: Insert | Field. The custom formula is "=Width*Height".

It displays with 4 decimal places of accuracy. Can I get it to round to 0 or 1?
Logged
Using Visio 2019, part of Office 365 on Windows 10

aledlund

  • Hero Member
  • *****
  • Posts: 1412
Re: Can I specify a formula and a format string?
« Reply #1 on: November 14, 2011, 12:01:20 PM »
david parker shows how to format a custom string in shape data over here
http://davidjpp.wordpress.com/2011/10/13/formatting-custom-units-in-visio/
al
Logged

Jennifer

  • Hero Member
  • *****
  • Posts: 553
Re: Can I specify a formula and a format string?
« Reply #2 on: November 14, 2011, 12:58:05 PM »
I feel really silly. The answer is easy and should have been obvious. All I had to do it select the proper format from the Fomat list. Duh.
Logged
Using Visio 2019, part of Office 365 on Windows 10

aledlund

  • Hero Member
  • *****
  • Posts: 1412
Re: Can I specify a formula and a format string?
« Reply #3 on: November 14, 2011, 02:26:31 PM »
we always learn more from our mistakes than from our successes
 ;D
al
Logged
Pages: [1]   Go Up
« previous next »