Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
replace "." with "/"
Select that column
edit|replace what: . (dot) with: / (slash) replace all 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 -- omneo -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
replace "." with "/"
Highlight the entire area and press Ctrl+H and under find what put . and replace by / -- William Okumu ------------------------------------------------------------------------ William Okumu's Profile: http://www.excelforum.com/member.php...o&userid=33745 View this thread: http://www.excelforum.com/showthread...hreadid=535643 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
REPLACE outside of highlighted column | Excel Worksheet Functions |