Date and Time Stamp?

[Ody]

Hello all,

I have an odd situation. I received a file with a date time stamp; nothing terribly unfamiliar.

However, the time stamp is formatted: dd/mm/yyyy H:MM

I can't seem to flip the date around so it's MM/DD/YYYY. Any thoughts?

Thanks...

 

[Trevor G]

Could you show some sample data.

Currently i added this then changed to another format and showing the custom format Select Column or cell then use Ctrl + 1 and then select custom

Excel Workbook
	C	D	E
1	Dates	Change format	Custom Format
2	01/08/2011 8:30	08/01/2011 08:30	mm/dd/yyyy hh:mm
Sheet1

 

[Ody]

My date looks like this: 24/7/2010 9:59, where 24 is the day, 7 is the month.

As soon as I made this post I figured out how to separate out the information I needed (which figures ).

What I did was text to columns separating by "/" which isolated the day and month for me (the original source of my problem). From there I was able to format and recreate what I needed.

Thanks!

 

[Trevor G]

Pleased to read you resolved your thread.