Insert a comma in middle of a cell value?

[Giovanni]

I have a date in A1, listed as May 09 2009. Because there is no comma in the middle, it is not recognized as an actual Date.

In Cell B1, I'm trying to bring over A1 value and add a comma to it so the end result is May 09, 2009

Any thoughts?

thanks!

 

[Jonmo1]

Try

=DATEVALUE(SUBSTITUTE(A1," ",", ",2))

format the formula cell as a date.

 

[c_m_s_jr]

If you prefer something a little complicated:

Excel Workbook
	A	B
1	May 09 2009	5/9/2009
2	December 11 2009	12/11/2009
Sheet1

 

[Giovanni]

Brilliant!! thank you both.

Gio