HotNumbers
Well-known Member
- Joined
- Feb 14, 2005
- Messages
- 732
Is there a way to identify with a formula on an adjacent cell on what format is used on a cell
Excel Workbook | ||||
---|---|---|---|---|
F | G | |||
2 | mm/dd/yyyy | 12/02/2011 | ||
3 | m/d/yyyy | 03/12/2011 | ||
4 | General | |||
5 | 0.0 | 22.2 | ||
6 | ddd/dd/mmm/yyyy | Wed/09/Mar/2011 | ||
Sheet |
Function NumberFmt(cll)
Application.Volatile
NumberFmt = cll.NumberFormat
End Function