Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
change date
I have a list with dates
8/18/05 I want to change them to 8/18/06 I tried using the find and replace i.e. find ?/?/2005 replace ?/?/2006 it finds the cells but replaces with ?/?/2006 What do I put in the replace to leave the month and day alone? oldjay |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
change date
Even though the dates display as 8/18/06...if you check the formula bar,
you'll see that that date is actually 8/18/2006. So, try this: Select your date range EditReplace Find what: /2005 Replace with: /2006 Click [Replace All] Does that help? *********** Regards, Ron "Oldjay" wrote: I have a list with dates 8/18/05 I want to change them to 8/18/06 I tried using the find and replace i.e. find ?/?/2005 replace ?/?/2006 it finds the cells but replaces with ?/?/2006 What do I put in the replace to leave the month and day alone? oldjay |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
change date
oldjay,
If they are truly dates, then simply type 365 into blank cell, copy it, select the cells with the dates, and select pastespecial, add, values, ok. HTH, Bernie MS Excel MVP "Oldjay" wrote in message ... I have a list with dates 8/18/05 I want to change them to 8/18/06 I tried using the find and replace i.e. find ?/?/2005 replace ?/?/2006 it finds the cells but replaces with ?/?/2006 What do I put in the replace to leave the month and day alone? oldjay |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
change date
oldjay
Just replace the 2005 with 2006. Excel is smart enough to make the change. For experiment try this. Format 8/18/05 as dddd and returns Thursday Now change 05 with 06. The dddd will change to Friday which is 8/18/06 Gord Dibben Excel MVP On Thu, 15 Dec 2005 13:06:12 -0500, "Oldjay" wrote: I have a list with dates 8/18/05 I want to change them to 8/18/06 I tried using the find and replace i.e. find ?/?/2005 replace ?/?/2006 it finds the cells but replaces with ?/?/2006 What do I put in the replace to leave the month and day alone? oldjay |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
change date
Ctrl -H
Replace 05 with 06 Ok :o) -- @---}-- Laura..... :) Liverpool, England "Oldjay" wrote in message ... : I have a list with dates : 8/18/05 : I want to change them to 8/18/06 : I tried using the find and replace : i.e. find ?/?/2005 : replace ?/?/2006 : it finds the cells but replaces with ?/?/2006 : What do I put in the replace to leave the month and day alone? : oldjay : : |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
change date based on time | Excel Discussion (Misc queries) | |||
Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
Why Does Date Format Change on Chart | Excel Discussion (Misc queries) | |||
How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) |