INDEX MATCH but need to change return Values


S

sam

Hi everyone,

Here is my drama. I am using an index & match and everything works fine. The
value that it is returning is correct but it is in the wrong format. It is a
date but displayed as 20090410 (yyyymmdd). I need it to return 10/04/2009
(dd/mm/yyyy).

Any ideas?

cheers

Sam
 
Ad

Advertisements

J

Jacob Skaria

If the return value is a text string you can try the below...and format the
formula cell to a date format of your choice

=DATE(left(formula,4),mid(formula,5,2),right(formula,2))

If this post helps click Yes
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top