Re: Formatting

Giganews Newsgroups
Subject: Re: Formatting
Posted by:  swatsp0p (swatsp0p.282bao_1148055004.8731@excelforum-nospam.com)
Date: Fri, 19 May 2006

Question:  Are cells A1 in both sheets truly dates?  Remember that Exce
stores dates as a number (e.g. May 19, 2006 = 38856).  To check, chang
the format of each cell to General and see if you get a number simila
to my example.  If not, then you don't have true dates in each cel
(maybe one is a text entry?).

HTH

Bruc

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=1510
View this thread:http://www.excelforum.com/showthread.php?threadid=54376

Replies

In response to

Formatting posted by nick on Fri, 19 May 2006