Thread
:
Is there a way to change all dates in a spread sheet
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Is there a way to change all dates in a spread sheet
editreplace0607
--
Don Guillett
SalesAid Software
"delete automatically" wrote
in message ...
I have a spread sheet with dates for the whole year of 2006. Exmaple I have
1/1/06 thru 1/15/06 in the first 14 rows. Then rows 15 thru 20 have other
data. Then start with 1/16/06 thru 1/29/06 then more data. How can I
changed
the dates to the right dates of 2007 without gong to each block of dates.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett