ExcelBanter - View Single Post

[email protected]

=Datevalue(A1) returns a #VALUE! error

JMay wrote:
With your current date (as text) in A1 enter in B1:
=DATEVALUE(A1) << will return a number where Istext(B1) = FALSE
Format B1 as Date;
HTH

" wrote in message
ps.com:

ISTEXT Formula returns a TRUE value
But the Data/Text to Columns function was not successful in changing
the format

Ron Rosenfeld wrote:
On 20 Dec 2006 19:40:40 -0800, wrote:

I'm using data that has been exported out of a proprietary database
into excel. The dates are formatted as "General" and no matter what I
do, I cannot change them to "Date" format (or any other format for that
matter). Has anybody encountered this?

The dates are probably TEXT. (see what you get with a formula
=ISTEXT(cell_ref)

There are a number of methods to convert them, depending on how your data is
set up.

If the data is in a column, and if you select Data/Text to Columns, you may be
able to change the format appropriately at Step 3.

If that doesn't work, post more details.
--ron