RE: An Excel question
- From: "Joe Smith" <joesmith55@xxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Thu, 6 Jan 2011 16:24:05 -0800
Bob, The only thing I could suggest is to check the format of that cell.
Press control-1 and tab and scroll to the date selection, and make sure that
specific cell has the same date format as the others. I took a look at my
Excel 2010, and there are several selections of formatting the date and it
maybe the problem.
Joe
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On Behalf
Of Onward Bob
Sent: Thursday, January 06, 2011 3:23 PM
To: jfw@xxxxxxxxxxxxx
Subject: An Excel question
This is a strange one. On a worksheet when I enter 1-5 in a date column it
reads 5-Jan., which is fine. Only on one line when I enter 1-5 it reads
Jan. 11, and nothing I do can stop it, regardless of what I enter in that
cell. help!
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5765 (20110106) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
Other related posts:
