[mso] Excel problems
- From: "Peter A. Wilson" <pawilson@xxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Wed, 24 Aug 2005 14:30:36 -0400
This was emailed to me from a user having problems with her Excel. Any
help would be appreciated.
1st problem is that the CSF's (Contract Sales Forms in a protected Excel
document emailed to me from the branches - at least 3 different people)
have check boxes and drop down boxes. When I open them the drop down
boxes change location on the sheet, if I close the form without saving
and reopen it, the boxes are where the moved to. As soon as I do
anything to the form the boxes move again. Cyndee can open the same
form and none of that happens.
=20
2nd problem I had was with 16 digit numbers I was entering into a
spreadsheet I created. The last digit of the number was "defaulting" to
"0". For instance, I would type "1234567890123456" and as soon as I
exited edit mode the number would change to "1234567890123450." If I
went back to it to fix it, it would just change it back again. I could
add all the zero's I wanted but the last digit would always return to
zero. I got around that finally by formatting to text, which at first
converted the number to scientific notation, but when I opened each cell
to change the last digit, it corrected itself. =20
Peter A. Wilson
Network Administration/Support
=20
=20
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Dian D. Chapman
Sent: Thursday, August 04, 2005 12:22 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: How Can I Delete Jewish Holidays?
If you're using 2003, you can click the Events view and just delete =3D
them.
Can't remember if this was available in prior versions.=3D20
Dian D. Chapman, Technical Consultant
Microsoft MVP, MOS Certified
Editor/TechTrax Ezine
Free Tutorials: http://www.mousetrax.com/techtrax Free Word eBook:
http://www.mousetrax.com/books.html
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On =3D
Behalf Of K. Waters
Sent: Thursday, August 04, 2005 11:00 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] How Can I Delete Jewish Holidays?
Hello, I really need some help here. I used to work for a couple who
were Jewish and it was important to remember all the holidays. Now I
have gone =3D93in another direction=3D94 and the holidays are littering =
up =3D
my calendar. HELP!
=3D20
Kathleen Waters
HYPERLINK "mailto:kwaters1234@xxxxxxxxx"kwaters1234@xxxxxxxxx
23969 NE State Route 3, Suite G-401
Belfair, WA 98528
=3D20
=3D20
--=3D20
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.2/52 - Release Date: 7/19/2005
=3D20
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
=3D or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to=3D20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the =3D
quotes)
in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will =3D
also allow you to change your email settings to digest or vacation (no
mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, =
=3D
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an =
=3D
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
--=3D20
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.0/63 - Release Date: 8/3/2005
=3D20
--=3D20
This email scanned and certified clean by AVG!
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.0/63 - Release Date: 8/3/2005
=3D20
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
