 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2005Find/Replace Date Question
Using Excel 2003. Problem replacing a series of dates having a date format of dd/mm/yy. I want to replace all dates ending with /05 with /06. I enter in the Find box /05 and in the Replace box /06 Error is "Microsoft Office cannot find a match" I never had this problem with earlier versions of Excel. TIA Jim If those are real dates, try replacing 2005 with 2006. > Using Excel 2003. > [quoted text clipped - 9 lines] > > Jim  SignatureDave Peterson Check the cell contents of one of the cells (in the formula bar).... Is the date like: 1/1/05 or (more likely) is it like 1/1/2005 If the latter, then find /2005 and replace it with /2006 Does that help? *********** Regards, Ron XL2002, WinXP-Pro > Using Excel 2003. > [quoted text clipped - 9 lines] > > Jim Great, thanks to all. The format was 1/1/2005 and not what I thought. Jim > Check the cell contents of one of the cells (in the formula bar).... > [quoted text clipped - 27 lines] >> >> Jim |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.