You need to change the cell's format to date. This can be accomplished with control+number 1.
-- Chris Hallsworth e-mail: christopher...@googlemail.com MSN: ch9...@hotmail.com Skype: chrishallsworth7266 ----- Original Message ----- From: "Cliff Smales" <csma...@att.net> To: <blind-computing@jaws-users.com> Sent: Sunday, March 01, 2009 11:52 AM Subject: Re: [Blind-Computing] Strange thing happening with Excel Hello, again: I just brought up that worksheet, and put in todays' date, using the control-semicolon keystroke. The date read as it should, when inserted. When read back, it read as a different formula, altogether. 3/1/06 = 39873 Something is turned on that shouldn't be, and I'd love to know what it is. Cliff ----- Original Message ----- From: "Lennie Rinaldi" <merlin...@mchsi.com> To: <blind-computing@jaws-users.com> Sent: Saturday, February 28, 2009 10:47 PM Subject: Re: [Blind-Computing] Strange thing happening with Excel > Cliff, > > I don't really understand what your problem is. I have a question for you. > How come the date is shown with dashes instead of slashes? You have 2-6-09 > whereas I normally use 2/6/09. > > Are you saying that the date and the number that represents the date is in > your cell? I went into Excel and typed your first date and when I did a > Ctrl+F2 on that cell, the result was 39850, but that number is the formula > for the date which is not displayed with the date. I am wondering if there > is some feature in Excel that displays the formula with the data? . > > Lennie > > At 09:46 AM 2/28/2009, you wrote: >>I'm a long-time excel user, and have come up against a problem that really >>has me baffled. >> >>For the first time in the many years I've used Excel, I had to go to the >>third sheet in the book. >> >>For the most part, everything entered as I expected it to. The dates, >>however, came outreally st >> >>For the four Fridays in February, the results came out as follows, even >>though theyread correctly when typed >> >>2-6-09 39850 >>2-13-0939857 >>2-20-09 39864 >>2-27-09 39871 >> >>Is there something turned on that I should pull the plug on? >> >>I'd appreciate any help anyone can offer. >> >>Cliff Smales >> >> >> Visit the JAWS Users List home page at: >> http://www.jaws-users.com >>Visit the Blind Computing home page at: >>http://www.blind-computing.com >> Address for the list archives: >> http://www.mail-archive.com/blind-computing@jaws-users.com/ >> To post to this group, send email to >> blind-computing@jaws-users.com >> To unsubscribe from this group, send an email to >> blind-computing-le...@jaws-users.com >> For help from Mailman with your account Put the word help in the subject >> or body of a blank message to: >> blind-computing-requ...@jaws-users.com >>Use the following address in order to contact the management team >>blind-computing-ow...@jaws-users.com >>If you wish to join the JAWS Users List send a blank email to the >> following address: >> jaws-users-list-j...@jaws-users.com > > > > Visit the JAWS Users List home page at: > http://www.jaws-users.com > Visit the Blind Computing home page at: > http://www.blind-computing.com > Address for the list archives: > http://www.mail-archive.com/blind-computing@jaws-users.com/ > To post to this group, send email to > blind-computing@jaws-users.com > To unsubscribe from this group, send an email to > blind-computing-le...@jaws-users.com > For help from Mailman with your account Put the word help in the subject > or body of a blank message to: > blind-computing-requ...@jaws-users.com > Use the following address in order to contact the management team > blind-computing-ow...@jaws-users.com > If you wish to join the JAWS Users List send a blank email to the > following address: > jaws-users-list-j...@jaws-users.com Visit the JAWS Users List home page at: http://www.jaws-users.com Visit the Blind Computing home page at: http://www.blind-computing.com Address for the list archives: http://www.mail-archive.com/blind-computing@jaws-users.com/ To post to this group, send email to blind-computing@jaws-users.com To unsubscribe from this group, send an email to blind-computing-le...@jaws-users.com For help from Mailman with your account Put the word help in the subject or body of a blank message to: blind-computing-requ...@jaws-users.com Use the following address in order to contact the management team blind-computing-ow...@jaws-users.com If you wish to join the JAWS Users List send a blank email to the following address: jaws-users-list-j...@jaws-users.com Visit the JAWS Users List home page at: http://www.jaws-users.com Visit the Blind Computing home page at: http://www.blind-computing.com Address for the list archives: http://www.mail-archive.com/blind-computing@jaws-users.com/ To post to this group, send email to blind-computing@jaws-users.com To unsubscribe from this group, send an email to blind-computing-le...@jaws-users.com For help from Mailman with your account Put the word help in the subject or body of a blank message to: blind-computing-requ...@jaws-users.com Use the following address in order to contact the management team blind-computing-ow...@jaws-users.com If you wish to join the JAWS Users List send a blank email to the following address: jaws-users-list-j...@jaws-users.com