Hi

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

Thanks
KAren

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

Dates are stored as simple numbers (the number of days since
0-Jan-1900), regardless of how they are formatted for display.
Changing the display format doesn't affect the underlying value of the
cell. Therefore, you can simply apply the English date format to the
cells. Select the cells to reformat, go to the Format menu, choose
Cells, and then the Number tab. Select Custom from the categrory list
and enter the English date format, something like dd/mm/yyyy or
whatever the English use. This will affect the displayed format, but
will not change the actual date values.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]






On Mon, 21 Dec 2009 04:07:01 -0800, Karen Souter
wrote:

Hi

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

Thanks
KAren