Hi Sandy
who did you get this numeric entry (by code or manual entry). As this
could never be the numeric representation of 09:00:00 (the value should
be below 1.0)
So also a format conversion won't help (as you stated in one of your
follow-ups)

--
Regards
Frank Kabel
Frankfurt, Germany

sandy wrote:
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 ?