Last modified: January 05, 2012
Applies to: Office 2013 | Visio 2013
Formulas can contain strings. To format string output, such as in a prompt cell, a shape data item value, or a text field, you specify a format picture. Output can be formatted as a number-unit pair, string, date-time, duration, or currency. For example, the format picture "0 #/10 uu" formats the number-unit pair 10.9cm as "10 9/10 centimeters".
You can use format pictures in the Format cell of the Shape Data section and as an argument to the FORMAT or FORMATEX function. When you insert a text field, format pictures appear in the list of formats in the Field dialog box (Insert tab).
You can format the displayed value of a shape data item by entering a format picture in the Format cell.
For example, a project timeline shape can have a shape data item that measures the cost of a process. By default, a shape data item value is a string. To format the string "1200", you can enter "$###,###.00" in the Format cell so that the user sees a currency.
Microsoft Visio uses the settings on the Currency tab in the Customize Format dialog box in the Region and Language item in Control Panel to determine the currency symbol and thousands separator to display. (In Control Panel, click Region and Language, and then click Additional Settings.)
To convert a string to a currency value so that you can perform calculations with the value, use the CY function.