-----Original Message-----
the time like
9:00:00AM was displayed as 4292552277.375 in excel
12:00:00PM was displayed as 4292552277.5 in excel

Can any one help me how to display in normal format
9:00:00AM ?
.


Did you try Format-Cells-Number-Time?

The programming language for this is (for the activecell):

ActiveCell.NumberFormat = "h:mm:ss AM/PM"