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