Thread: Dates
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Dates

One way:

Choose Edit/Replace...

Find: 04/
Replace with: 05/


However, you should note that replacing the 05/ in 05/31/2007 with 06/
will convert the entry to Text, since 06/31/2007 isn't a valid date. You
don't say how you'd want to handle that.



In article ,
dar wrote:

I have dates that are the same in each month ex.

04/15/2007
04/19/2007
04/25/2007

When april is over how can i just change the month to may and still have the
same days