Of course, you're right. I swear I tried it and it didn't work...

David Biddulph wrote:
You don't need the double unary minus. INT and MOD will cope with the text
entries.
--
David Biddulph

"Glenn" wrote in message
...
T. Valko wrote:
Assuming the date/time is a true Excel date/time...

A1 = 09/24/09 8:40

B1: =INT(A1)
Format as Date

C1: =MOD(A1,1)
Format as Time


And without assuming, I think you could just add "--" in front of A1 and
it works for either date/time or text entries.