On Tue, 19 Sep 2006 14:01:02 -0700, chazparks
wrote:

When I try this I get #VALUE! instead of a datatime.

A1 = 04/03/78
B1 = 12:00pm


You are entering the values incorrectly.

1. No <equal sign
2. There must be a space before the "pm"

A1: 04/03/78
B1: 12:00 P (or 12:00 pm)


--ron