Cell Formats

[Jeff Klein]

I know how to reference the value of a cell but is there a way o reference a
cells format?

 

[Gord Dibben]

Provide more details about what you wany to achieve, please.

There are ways to ascertain the formatting of a cell but generally would require
VBA


Gord Dibben MS Excel MVP

 

[Ron Rosenfeld]

I know how to reference the value of a cell but is there a way o reference a
cells format?

In VBA, you can access the numberformat property.

As a worksheet function, you can access SOME (not ALL) information using the
CELL worksheet function (see HELP for that).
--ron