Hi Karen, this is all I can come up with (in EXCEL 2007):-

1. In cell A 37 I have:-

2001-03-14

The Format Cells for this is (on the number tab):-

Date (for the Category:)

2001-03-14 (for the Type:)

So the above is the US format.

2. In cell B 37 I have:-

14 March 2001 (this is what displays)

=+A37 (this is the formula in the cell)

The Format Cells for this is (on the number tab):-

Date (for the Category:)

*14 March 2001 (for the Type:)

So the above is the UK format.

3. So I have converted the US format in cell A 37 to the UK format in cell B
37.

Please hit Yes if my comments have helped.

Thanks.


"Karen Souter" wrote:

Hi

Can anyone tell me how to convert a column of amercan dates to english,
please?

Thanks
KAren