DATEVALUE is a Date and Time function, and its purpose is to convert a date in the form of text to a serial number. In this post, we will show you how to use the DATEVALUE function in Microsoft Excel.

Yes, very easily with VBA. Coincidentally, I whipped one up for a similar date import problem I was having last week. Here is the code, you should be able to modify it for your needs:<BR><BR><pre ...

For example, the DATEVALUE function in the Date & Time category also returns a numeric value, which is the serial representation of a character string.