Hi cliff,
I went into Excel and brought up the third worksheet and inserted the
date. It read normally like it should. Also, I tried using the dash
and Excel inserted the date with slashes. At this time, I have no
other ideas what could be turned on. I checked view menu and nothing
jumped out at me.
I wish that I could be more help. Try inserting the date with the
NumPad keys using slashes and see if the date displays correctly.
Lennie
At 06:52 AM 3/1/2009, you wrote:
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" <[email protected]>
To: <[email protected]>
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/[email protected]/
To post to this group, send email to
[email protected]
To unsubscribe from this group, send an email to
[email protected]
For help from Mailman with your account Put the word help in the subject
or body of a blank message to:
[email protected]
Use the following address in order to contact the management team
[email protected]
If you wish to join the JAWS Users List send a blank email to the
following address:
[email protected]
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/[email protected]/
To post to this group, send email to
[email protected]
To unsubscribe from this group, send an email to
[email protected]
For help from Mailman with your account Put the word help in the subject
or body of a blank message to:
[email protected]
Use the following address in order to contact the management team
[email protected]
If you wish to join the JAWS Users List send a blank email to the
following address:
[email protected]
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/[email protected]/
To post to this group, send email to
[email protected]
To unsubscribe from this group, send an email to
[email protected]
For help from Mailman with your account Put the word help in the subject
or body of a blank message to:
[email protected]
Use the following address in order to contact the management team
[email protected]
If you wish to join the JAWS Users List send a blank email to the
following address:
[email protected]
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/[email protected]/
To post to this group, send email to
[email protected]
To unsubscribe from this group, send an email to
[email protected]
For help from Mailman with your account Put the word help in the subject
or body of a blank message to:
[email protected]
Use the following address in order to contact the management team
[email protected]
If you wish to join the JAWS Users List send a blank email to the
following address:
[email protected]
