Read the formatting of Cell in Excel VBA

[vikassarin]

How to read the formatting of the cells in excel vba to test the correctness of the format being displayed in the cell. e.g., the format of the cell displaying date is dd-mmm-yyyy and the value is 3/11/2011. It is been possible to read the value of the cell by Cells(2,5).Value but how the format of the cell would be read in excvel vba. The format can be set with Format function but how to read is not been known.

 

[truskawa]

have you tried:
Cells(2,5).NumberFormat

 

[vikassarin]

It works! Thanks alot!