Hi Robert,

Am Mon, 29 Apr 2013 12:28:25 -0700 schrieb Robert Crandal:

On my spreadsheet, cell "A1" shows the time of "9:50 PM".
However, when I run the following code:

MsgBox Range("A1").Value

the message box shows a time of "0.9097222222".

How do i fix this so it shows "9:50 PM" in the MessageBox?

try:
MsgBox Format([A1], "h:mm AM/PM")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2