VLOOKUP unwanted date formatting

**ianh** · 12-09-2011, 07:05 AM

could be the extra \ on the end of the format

**vicshippers** · 12-09-2011, 07:10 AM

The source cells are formatted as text, it's just that the data is in a date format.

**daddylonglegs** · 12-09-2011, 07:14 AM

Originally Posted by vicshippers

The source cells are formatted as text.....

Are you sure? If one of the source cells is C2 then what does this formula give you

=ISNUMBER(C2)

If the answer is TRUE then the cell is formatted as a date or number. I suspect the answer will be TRUE because VLOOKUP shouldn't change the result if it's text formatted