month change

[nowfal]

Hi,

I have entered wrong month in a spread sheet that is few rows
mean so many line. Now i wanted to change that with a formula or an
short cut. Will it possible to change.
the date format is in colomn A , it is like this 01/08/04, 02/08/04 an
so on, now i wanted to change the month 08 to 09.
ie.01/09/04,02/09/04 .
Any suggestion will be highly appreciated.
thanks
nowfa

 

[Jack Schitt]

What would you want 30/01/04 to change to?

 

[Don Guillett]

try
Sub changedate()
For Each c In Selection
c.Value = DateSerial(Year(c), Month(c) + 1, Day(c))
Next c
End Sub