How can I convert Euro dates into U.S. Date; e.g. dd-mm to mm-dd?

Riley001

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I create a schedule from a list of dates ?	Gavin Morris	Charts and Charting in Excel	2	October 28th 10 04:08 PM
Compare dates (one cell not in date format)	craigcsb	Excel Discussion (Misc queries)	5	June 28th 05 05:07 PM
Using a col of Dates by day I want to determine a wk ending date.	Ken Espo	Excel Worksheet Functions	4	February 3rd 05 11:03 PM
Using a col of Dates by day I want to determine a wk ending date.	Ken Espo	Excel Worksheet Functions	1	February 3rd 05 08:09 PM
How do I convert a Julian date into a regular date?	Jessica	Excel Discussion (Misc queries)	4	December 2nd 04 02:54 AM

All times are GMT +1. The time now is 02:34 PM.

Menu

About Us