Search results for query: *

I'm having some date formatting problems. I've looked at the following thread but was not able to resolve my problem. http://www.tek-tips.com/viewthread.cfm?qid=1409951 My excel file is found at this location. I could not upload it while on my work computer...

have a column of cells where users put in "Y" for yes and "N" for no. However, when i count the Y's and N's, if there is a space after the letter, it will not count the character. I can't depend on users to remove the spaces,they are not that computer literate. Besides spaces are hard to see...

Message: "This workbook contains links to other data sources. - If you update the links, Excel will attempt to retrieve the latest data. - If you don't update the links, Excel will use the previous information. Note that data links can be used to access and share confidential information...

One stupid thing i hate about Excel is the circular reference. Maybe it has a purpose but i don't see one. All i do is cut and past info in one cell to another and then the formula becomes a circular reference. How can i avoid this? Does protecting the sheet prevent circular references from...

I was trying to protect multiple worksheets at a time. So i selected the tabs at the bottom and started unchecking the Locked check box after going to Format Cells. But what i found out was that it was unlocking the first sheet but not all the following sheets. I have 40 worsheets in this book...

Is there a way to set page breaks for multiple sheets? I have 40 sheets and a total of 900 pages per sheet. Selecting all the tabs and trying to adjust the page breaks in Page Break Preview doesn't work. will changing the margins for all the sheets work? Any suggestions? Thanks!

I have a row of records. Underneath each row are criteria that the records must meet. If i put an N in one of the spaces, I would like for the record number to highlight in a different color. The formular i have is =COUNTIF($B$7:$B$24,"N")and it works BUT ONLY FOR THAT ONE COLUMN. How do i...

Is it possible to prevent or paste formulars to a workbook without the links changing? The problem is all of my links are only supposed to link ot pages within the current workbook. However, i have to create numerous copies of the workbook--one for each month of the year. What happens is that...

Ok i have several spreedsheets on a server used by various personnel. Is there a way to prevent formulas from being acccidentally changed?

I have a list of cells and i want to count if a Y for yes was placed in the cell. But since it is a table of items, i only want that row to be counted. However countif only takes a range. I can't say countif(a1,a5, a11, a16, "y"). Is there a good alternative.I have a lot of cells. Thanks!

Hi guys, I just got DSL from Bellsouth. We have more than one computer. On their website it says that i can set up a home network for $5 additionally a month. I thought that was strange. Why a monthly fee? Why can't i just use the same line and split it or something? Or use the lines in the...

I have a form and subform. They are both linked. In the main form there is a combo box with departments. In the subform is a datasheet of employee related info such as vacation time, sick time, etc. I want to use the combo box to display all the employees and their info in that department...