VLookup-DATE

[Mel]

I tried to copy a vlookup formula for a date column in my
table now the date column looks something like this
090001on my sheet instead of the date 09/01/01 on my
table. What am I doing wrong???

 

[Frank Kabel]

Hi
you first may convert the current value in your column to a real date.
Have you imported these values or have you applied a custom format for
this column?

 

[Mel]

I applied a custom format using mm\dd\yy after I entered
the dates.

 

[Frank Kabel]

Hi
but this does not seem to change the date representation 8looking at
your example). So I assume your values are probably stored as 'Text'?
Does chaning the custom format change the date representation?

 

[Jason Morin]

Changing the format as you did does not alter the contents
of the cells. Your values are still text. What Frank meant
was actually converting the strings to real dates. With
090101 (Sept 1, 2001) as an example, you could use:

=REPLACE(REPLACE(A1,3,,"-"),6,,"-")*1

Then format the cell as mm/dd/yy.

HTH
Jason
Atlanta, GA