Search results for query: *

Hello everyone, Using Excel 2002, I created a workbook with 30+ sheets/tabs. Each employee has a specific sheet that they are responsible for entering data which in turn reports back to sheet one labeled "Overview" Each employee was instructed to protect their "sheet" when done and save the...

Using Excel 2002. I have 10.3 days on a sheet. I am looking for an equation that would convert the 10.3 days to "10 Days" and "x" hours. We work under a 24hr schedule and are trying to calculate vacation days. Thank you Chris

Greetings: Using Excel 2003, I have a spreadsheet that I need to sort and keep the header row in place. I typically do not have a problem keeping the header row in place during the sort, however at times I have received sheets from different people that I can't isolate the header row during the...

Hello, Using Excel 2003 & Excel for Mac 2008. Can I make a cell required to have an entry? I have a cell that has a "data validation" list, I have the error code set to "stop" and have filled out the actual stop message. Can I make it so the person filling out the form has to enter a name...

Hello everyone, Using Excel 2003. I was just given a large spreadsheet with address' (example: 1234 Milky Way) entered into one cell that I would like to seperate into two cells (1234) & (Milky Way). I need to do this to be able to sort them better. I attended a advanced Excel class a...

I think this is an easy one, however I can't seen to find it the formula.... :o( Using Excel 2003, also using Excel 08 for Mac, I would like to have a cell (D3) return the last number in a column (B) I hope this is enough information for you. Thank you in advance for your help on this...

Hello all, Using Excel 2002, I have a sheet that contains employee names on rows. Next to each employee's name is a column named "Draw#1", then sucessive draws to the right. In the columns for each employee there is a drop down menu with the vendor names. After inserting the vendor's name...

I am working in iWorks 08, in Numbers, I want to lock the header row. (similar to "freezing" in Excel) I know how to repeat the header row, but I have a large file and when I scroll down, I can't see the headers. Any help would be appreciated!!! Chris

Greetings, In Excel 2002, I need to evaluate three dates in three seperate cells, A1, B1, C1 formatted as mm/dd/yy, and have the greater of the three dates displayed in the forth cell "D1" Any help would be very much appriciated. Chris

CorelDRAW 12 will not launch anymore. I keep getting an error saying "Unable to create a DOM document. Class not registered Verify that MSXML 4 is installed

I am sure it is conditional formatting, but stuck at the begining. In cell A1 I have the word "date" shadded light gray. The cell is formatted to be a date mm/dd/yy. When I enter a date in that cell, I would like the color of the text to change to Black showing the date mm/dd/yy. I thought I...

HI, I am using Excel 2002. I have used this site before a couple of years ago and have found it to be very, very helpfull. Here is my latest delema.. Thank you in advance. Problem 1: Cell B3 is formatted as a date mm/dd/yy. I would like it to add 45 days to a date entry which will be in cell...