Need help - How to identify the cell display format?

[Ezhilarasan Chandrasekar]

Hi folks,

I just want to find the cell display format in Excel. I have a Expected
excel file and Actual Excel file.

I have some knowledge about, how to check the cell value, cell font,
alignment. But I also want to know about what type of cell format is being
used.

For example: If the cell value has "*04:05:00 AM*", but it displays as "
*04:05:00*"(AM notation not needed) which is of format "*hh:mm:ss*"

I want to identify the cell format *(hh:mm:ss)* from Expected Excel file
and compare with the Actual Excel file

Please help me!

--
Warm regards,
Ezhilarasan