Convert numbers to date in text string

**daddylonglegs** · 09-21-2010, 05:23 AM

Hello Brian,

You can use the TEXT function for this. Enclose each of your VLOOKUPs in that function like this

TEXT(VLOOKUP(Sheet2!$C$2,Sheet2!$C$3:$G$14,4,FALSE),"d mmmm yyyy")

you can change the "d mmmm yyyy" to your preference for the date format

**singerbatfink** · 09-21-2010, 05:58 AM

Originally Posted by daddylonglegs

Hello Brian,

You can use the TEXT function for this. Enclose each of your VLOOKUPs in that function like this

TEXT(VLOOKUP(Sheet2!$C$2,Sheet2!$C$3:$G$14,4,FALSE),"d mmmm yyyy")

you can change the "d mmmm yyyy" to your preference for the date format

Absolutely Perfect..

Thanks very much..

Brian