Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I convert Euro dates into U.S. Date; e.g. dd-mm to mm-dd?
I need to convert dates that are in dd-mm format to mm-dd-yr format. How can
I do this? The dates originally appear like this: 24.06 which further complicates the matter. I'm using EXCEL '97. |
#2
|
|||
|
|||
Maybe you could use a column of helper cells:
With 24.06 in A1, I put: =DATE(2005,RIGHT(A1,2),LEFT(A1,2)) in B1 and dragged down And formatted it the way I wanted. Riley001 wrote: I need to convert dates that are in dd-mm format to mm-dd-yr format. How can I do this? The dates originally appear like this: 24.06 which further complicates the matter. I'm using EXCEL '97. -- Dave Peterson |
#3
|
|||
|
|||
THANK YOU, THANK YOU, THANK YOU. Excellent. It worked !!!!!
YOU'RE a genius. Thank you so very much. "Dave Peterson" wrote: Maybe you could use a column of helper cells: With 24.06 in A1, I put: =DATE(2005,RIGHT(A1,2),LEFT(A1,2)) in B1 and dragged down And formatted it the way I wanted. Riley001 wrote: I need to convert dates that are in dd-mm format to mm-dd-yr format. How can I do this? The dates originally appear like this: 24.06 which further complicates the matter. I'm using EXCEL '97. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
Using a col of Dates by day I want to determine a wk ending date. | Excel Worksheet Functions | |||
Using a col of Dates by day I want to determine a wk ending date. | Excel Worksheet Functions | |||
How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) |