Convert numbers to date in text string

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

Hi Folks

Ive put together a string of text which can change depending on the month selected for the dropdown.

I would like it to display dates but cant converts the formula to show actual dates instead of numbers.

I have attached a copy of my problem in a small workbook.

Any help much appreciated.

Brian

**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