wks.col.subformat

Syntax

wks.col.subformat

Type

numeric

Access

Read/write

Description

Subformat options as listed in the Display drop-down list of the Worksheet Column Format dialog box (select from main menu Format: Column ... to open this dialog). To get the appropriate number of the option you want, simply count down from the top of the list of Display options, starting from 1. For example, 1 stands for "7/30/2020", the 1st entry. and 22 is "Custom Display", the last entry. Please note that options "2020-W34" and "2020-W34-3" are newly added, so they are indexed after "Custom Display". That is, 23 for "2020-W34", and 24 for "2020-W34-3". Make sure the desired Format has been selected first.

Examples

See also

wks.col.setformat(), wks.col.format