Excel date formats

Alex · 10-26-2006, 03:03 PM

Hmmm...wish I had a copy of Excel handy to poke around with. It shouldn't be difficult. But all I have in the house is Works, which is just Excel light and it is automatically translating "Oct 5, 1999" to "October 5, 1999" and accepting whatever date formatting I put on it.

Ghoulish Delight · 10-26-2006, 03:07 PM

Quote:

Originally Posted by Alex Stroup

Hmmm...wish I had a copy of Excel handy to poke around with. It shouldn't be difficult. But all I have in the house is Works, which is just Excel light and it is automatically translating "Oct 5, 1999" to "October 5, 1999" and accepting whatever date formatting I put on it.

For me, if I put "Oct 5, 1999" it happily converts it to whatever I want. But "Oct 5 1999" stays "Oct 5 1999"

Alex · 10-26-2006, 03:08 PM

You could always use a calcuation column to translate the input text structure to the correct structure for what Excel wants.

=LEFT(A1, 6) & ", " & LEFT(RIGHT(A1, 12), 10) & " " & RIGHT(A1, 2)

(Or something like that, that is all from my head and untested. This would convert Oct 5 1999 06:23AM to Oct 5, 1999 06:23 AM)

10-26-2006, 03:03 PM	#1
Alex . Join Date: Feb 2005 Posts: 13,354	Hmmm...wish I had a copy of Excel handy to poke around with. It shouldn't be difficult. But all I have in the house is Works, which is just Excel light and it is automatically translating "Oct 5, 1999" to "October 5, 1999" and accepting whatever date formatting I put on it.
	Submit to Quotes

10-26-2006, 03:08 PM	#3
Alex . Join Date: Feb 2005 Posts: 13,354	You could always use a calcuation column to translate the input text structure to the correct structure for what Excel wants. =LEFT(A1, 6) & ", " & LEFT(RIGHT(A1, 12), 10) & " " & RIGHT(A1, 2) (Or something like that, that is all from my head and untested. This would convert Oct 5 1999 06:23AM to Oct 5, 1999 06:23 AM)
	Submit to Quotes