Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Format Cell (Text Fields Section)
Collapse the table of content
Expand the table of content

Format Cell (Text Fields Section)

Last modified: June 17, 2011

Applies to: Office 2013 | Visio 2013

Specifies the formatting of a text field that is a string, a number, a date or time, a duration, or a currency.

If the value of the Type cell is 0, 2, 5, 6, or 7 (string, number, date or time, duration, or currency, respectively), specify a format picture appropriate for the data type. For example, the format picture "# #/4 UU" formats the number 12.43 in. as 12 2/4 INCHES. For more information about specifying a format picture, see About format pictures.

A number (Type = 2) can represent a dimension, scalar, angle, date, time, or currency. To ensure that an input number is always evaluated as a date, time, or currency, use the DATETIME or CY function in the Format cell instead of a format picture.

To get a reference to the Format cell by name from another formula, or from a program using the CellsU property, use:

Cell name:

where i = <1>, 2, 3...

To get a reference to the Format cell by index from a program, use the CellsSRC property with the following arguments:

Section index:


Row index:

visRowField + i
where i = 0, 1, 2...

Cell index:


© 2015 Microsoft