View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sam Sam is offline
external usenet poster
 
Posts: 699
Default INDEX MATCH but need to change return Values

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