Prev: How do I view complete text content in an Excel Comment box?
Next: Converting irregular Word table to spreadsheet
From: Dave Peterson on 25 Apr 2010 12:13
Another one:

=--(B1&C1&A1)

And give the cell with the formula the format you like (dd/mm/yyyy)



Graham wrote:
>
> I have dates shown as:
>
> A B C
>
> 2010 5 Mar
>
> I need them to change to 1 cell in the format 05/03/2010
>
> Can anyone help??
> ThanKS
> Graham

--

Dave Peterson
First  |  Prev  | 
Pages: 1 2
Prev: How do I view complete text content in an Excel Comment box?
Next: Converting irregular Word table to spreadsheet