Thread
:
Is there a way to change all dates in a spread sheet
View Single Post
#
4
Posted to microsoft.public.excel.misc
Jon Peltier
external usenet poster
Posts: 6,582
Is there a way to change all dates in a spread sheet
Excel stores the dates as 1/1/2006, so it won't find any instances of "/06"
to change. "\2006" and "/2007" do work.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Don Guillett" wrote in message
...
or maybe
replace
/06
/07
--
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
Jon Peltier
View Public Profile
Find all posts by Jon Peltier