omneo

Junior Member

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF formula in Excel / Replace numbers with 'words'	Emsmaps	Excel Discussion (Misc queries)	1	April 7th 06 11:01 PM
Excel: Add replace within selection functionality	Marcel XL	Excel Discussion (Misc queries)	1	March 3rd 06 01:51 PM
Search and replace	Subu	Excel Worksheet Functions	4	June 9th 05 07:01 PM
replace absolute references	bj	Excel Worksheet Functions	0	May 20th 05 07:18 PM
REPLACE outside of highlighted column	Jane	Excel Worksheet Functions	8	May 19th 05 01:54 PM

All times are GMT +1. The time now is 08:19 PM.

About Us

"It's about Microsoft Excel"