Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Format Cell (Shape Data Section)

Published: July 16, 2012

Specifies the formatting of a shape data item that is a string, a fixed list, a number, a variable list, a date or time, a duration, or a currency.

Shape data item type

Value

Format cell contents

String

0

A format picture appropriate for the data type.

Fixed list

1

The items to appear in the list, separated by semicolons.

Number

2

A format picture appropriate for the data type.

Variable list

4

The items to appear in the list, separated by semicolons.

Date or time

5

A format picture appropriate for the data type.

Duration

6

A format picture appropriate for the data type.

Currency

7

A format picture appropriate for the data type.

As an example of specifying a format picture appropriate for the data type, 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.

An example of specifying items for a list is "Engineering;Human Resources;Sales;Marketing".

Date values (type = 5) are displayed in the short date format. Currency values (type = 7) are displayed using the user's current setting for Currency on the Regional Options tab in the Regional and Language Options item in Control Panel.

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:

Prop.name.Format
where Prop.name is the row name

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

Section index:

visSectionProp

Row index:

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

Cell index:

visCustPropsFormat

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.