Get Cell Format

Read a cell's number format string.

ExcelExcelGetFormatCell

What it does

Read a cell's number format string.

Parameters

ParameterTypeRequiredDefaultDescription
Excel instancevariable
RequiredexcelName that identifies this open workbook.
Sheet (blank = active)string
OptionalWorksheet name; blank uses the active sheet.
Supports variables
Reference bydropdown
A1 (Cell) · Row & Column
OptionalA1 (Cell)
Cell (A1) — for A1 modestring
Optional
Example: A1
Supports variables
Row (1-based) — for Row & Column modenumber
Optional
Example: 1
Supports variables
Column (1-based) — for Row & Column modenumber
Optional
Example: 1
Supports variables
Store format invariable
Required
Example: fmt

More Excel commands

Ready to automate your busywork?

Start your free 10-day trial today. No credit card, no commitment.