Coversion problem

[WayneF]

Hi I am trying to get information from 4 cells.

The 4 cells are ...

2006-01-07
Week
01
.xls

The formula I have is this ...

=LEFT(M10,10)&LEFT(N10,10)&(LEFT(O10,10)&LEFT(P10,10))

Maybe not the best way but it works. The problem is i want this Result
....

2006-01-07 week 01.xls

And I get this result .....

38724 Week 01.xls

Where the date is represented by the value not the date
I am using the format yyyy-mm-dd;@ for the date ( as a side note if any
one can tell me why i need the ";@"


Cheers,

Wayne

 

[Dave Peterson]

M10 is a real date.

=text(M10,"yyyy-mm-dd") & .....

 

[WayneF]

As always Dave you have done it again )

M10 is a real date.

=text(M10,"yyyy-mm-dd") & .....