Hi cliff,
I had a similar problem when using multiple worksheets in Excel.
On my third worksheet, every time I entered a date using slashes, the
resulting date read by Jaws was somewhere around 1900. It was not the
same problem you had with your dates,
I had to open up a new book and typed the date there and format it to
display what I was looking for. I then copied that date and pasted it
in the third worksheet.
I got around this problem by doing the same thing you did. I created
a fourth worksheet and made all my entries there. I deleted the
third worksheet and the fourth one became the new third one.
I tried everything to correct the problem in the original third
worksheet, but I couldn't make it work. I have no idea how this
problem can be solved other then creating a new worksheet.
Apparently, the format in a cell just cannot be changed once you
establish the date format. Weird, I know!
Lennie
At 09:35 PM 3/5/2009, you wrote:
I inserted a fresh worksheet into the book that I'm working with. My
dates came out exactly as they should.
I don't understand, however, why there should be this change from
regular date notation to the internal numeration on the third sheet.
Can someone shed any light on this for me?
Cliff Smales
----- Original Message ----- From: "Carlene knight"
<ckni...@knight-toolworks.com>
To: <blind-computing@jaws-users.com>
Sent: Thursday, March 05, 2009 8:58 PM
Subject: Re: [Blind-Computing] Strange thing happening with Excel
=Today() or =Now() if you want the time as well as the date. Hope that
helps.
-----Original Message-----
From: blind-computing-boun...@jaws-users.com
[mailto:blind-computing-boun...@jaws-users.com] On Behalf Of Donald Marang
Sent: Sunday, March 01, 2009 12:20 PM
To: blind-computing@jaws-users.com
Subject: Re: [Blind-Computing] Strange thing happening with Excel
I was attempting to rename a sheet last night in Excel 2007. Since I could
not find this option in the ribbons, I was reading through the Excel help
regarding sheets. I still could not find this option in the ribbons, so I
used the JAWS cursor to find and right click on the sheet tab. Anyway, it
was clear in the help pages that Excel's default for a new document is to
use a template with 3 sheets. Perhaps the default template has different
cell formatting on the third sheet? If so, it should be easy to open the
default template, delete the third sheet, insert a new sheet based on one of
the first two sheets and save as the default template.
Don Marang
----- Original Message ----- From: "Chris Hallsworth"
<christopher...@googlemail.com>
To: <blind-computing@jaws-users.com>
Sent: Sunday, March 01, 2009 6:55 AM
Subject: Re: [Blind-Computing] Strange thing happening with Excel
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
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
