View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default Changing the date in a cell

Fri, 4 Jan 2008 16:41:32 -0000 from Bob Phillips
:
Just do a global replace on 2007 for 2008.


Indeed, that works, but why? I thought all dates and times were
stored internally as real numbers.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/