| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace "." with "/" | Excel Worksheet Functions | |||
| IF formula in Excel / Replace numbers with 'words' | Excel Discussion (Misc queries) | |||
| Excel: Add replace within selection functionality | Excel Discussion (Misc queries) | |||
| Search and replace | Excel Worksheet Functions | |||
| replace absolute references | Excel Worksheet Functions | |||
Linear Mode
