replace "." with "/"
 

hi

ive got a LONG list of details with the date entered as 12.12.2005
instead of 12/12/2005. is there a way to change the . for a /

thanks
omneo


--
omneo
------------------------------------------------------------------------
omneo's Profile: http://www.excelforum.com/member.php...o&userid=33780
View this thread: http://www.excelforum.com/showthread...hreadid=535511

replace "." with "/"
 

Hi,

If this is in an Excel column, select the column, Edit, Replace, put .
in the Find What, and / to replace with, and Replace All.

Hope this helps

--

omneo Wrote:
hi

ive got a LONG list of details with the date entered as 12.12.2005
instead of 12/12/2005. is there a way to change the . for a /

thanks
omneo


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535511

replace "." with "/"
 

exactly what i was looking for

thanks


--
omneo
------------------------------------------------------------------------
omneo's Profile: http://www.excelforum.com/member.php...o&userid=33780
View this thread: http://www.excelforum.com/showthread...hreadid=535511