If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Convert Amercan dates to English dates
Hi
Can anyone tell me how to convert a column of amercan dates to english, please? Thanks KAren |
#2
|
|||
|
|||
Convert Amercan dates to English dates
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 |
#3
|
|||
|
|||
Convert Amercan dates to English dates
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 |
Thread Tools | |
Display Modes | |
|
|