Cyrus,

why don't you mail me the workbook

bob (dot) phillips (at) tiscali (dot) co (dot) uk

do the obvious with the bits in brackets

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Cyrus" wrote in message
...
I know nothing about VB.

I right clicked on tab, view code, pasted your code into my worksheet 1,
saved and closed VB. I then went into worksheet and typed "1230p" and it
still doesn't display "12:30 PM"

Thanks for being so patient with me...just don't know anything about
Visual
Basic.