determine how a cell is formatted

[Sean Farrow]

Hi:
How can I determine how a cell or range is formatted.
I'm thinking things that could afect the cell.value property, i.e decimal
places etc.
Chers
Sean.

 

[Rick Rothstein]

Use the NumberFormat property...

MsgBox Range("A1").NumberFormat

 

[Gary''s Student]

Sub whatformat()
MsgBox (ActiveCell.NumberFormat)
End Sub