When I open a .doc it shows all the changes that everyone has made in red. I'd like the .doc to open without showing the changes. I went to Tools-Options-Edit and removed the check mark in "Keep Track of Formatting". The .doc still opens showing the changes.
Thanks
Sopman
I have a field that contains email addresses. Is their a way to get the email addresses in access into Yahoo mail?
I tried saving them in excel as a .csv file, but could not import them into yahoo mail.
Sopman
I'm keeping the database for little league. In "Forms" I have fields labeled "birthday", "league age", and "Apr 15, 2007".
What I would like to do is when the birthdate is enter I need that to subtract from Apr 15, 2007 to give me the league age of the player. Is there a way to calculate this...
I'm trying to transfer my MS Outlook Personnel Address Book (.PAB) into my Yahoo email account. I'm having troubles making the .PAB into a .CVS so that yahoo can import it.
I don't want to import my "Contacts", just my Personnel Address Book.
Can someone help me?
Sopman
In my Excel spreadsheet I have a separate sheet that has the "Lookup" values. This sheet is called "Data". On a different sheet I have this command,
=LOOKUP(K6,DATA!K5:K400:DATA!L5:L400)
The value I had in K6 use to match up correctly with what was in the "Data" sheet. Everything worked...
Somedays have data in cells A1,A2,A3,A4,A5,A6
Somedays I have data in A1,A2
Somedays I have data in A1,A2,A3,A4
I'll always have data in A1 and as more data comes in it will go in the next cell, but the most data I will have will be in A1:A6. The least could be just in A1. I never know which...
Somedays have data in cells A1,A2,A3,A4,A5,A6
Somedays I have data in A1,A2
Somedays I have data in A1,A2,A3,A4
I'll always have data in A1 and as more data comes in it will go in the next cell, but the most data I will have will be in A1:A6. The least could be just in A1. I never know which...
In cell "A1" I have a date "7/13/2006"
In cell "B1" I have a time "1:45 PM"
How do I combine both columns into one column with a "space" between the date and time?
Thanks
Sopman
I have a spreadsheet that has the schedule of basketball games/practices for all teams. Is there a way to sort out just our team? We are team 5.
In column E this is what it looks like: Game 2 & 5
Plus it has other teams playing: Game 3 & 4
Thanks
Sopman
I'm trying to do the Search command "containing text", but having problems with the text I'm entering. It is ##.00
For some reason it doesn't like the #. I get a parameter error message.
Is there anyway around this?
Thanks
Sopman
I'm a user on a network. I had to rebuild my profile. We renamed the old profile, so I still have it.
I've lost all my macro's in excel. Does anyone know what file I need to transfer over to the new profile to get my macro's?
Sopman
I have an excel file on floppy that I can't open, move or copy. I've tried DOS xcopy, Advance Excel Repair v1.4 (from the internet.
Does anyone know of a good repair file software for excel 2000?
Sopman
I'm able to use the Offset in the Insert-Name-Define to update my chart automatically, which has multiple lines, but my legend doesn't display the title for each line. It only comes up Series 1, Series 2, etc.
Is their a way change the legend to reflect what each line represents on my data...
I have about 300 entries to put into a spreadsheet with differents dates. I would like to enter the date like 031005 and have it be displayed as 03/10/05. I tried Format-Cell, but it converts it to a different date. Is there a way to do this?
Sopman
I have Office2000. I'm not sure what happen, but in an excel spreadsheet my file looks like someone click on the box in the upper right-hand corner to size the spreadsheet. I put the mouse on the edge of the file to size it, but I don't get the double arrow. Also, I can't drag the title bar...
How do I count up the "R" that will be put in one row, but in different columns? Columns will consist of number of days in a month. So if the 2nd, 5th, 12th and 22nd days have an "R" in them, what formula would you write to get it to add up to 4?
Sopman
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.