Search results for query: *

I currently have an "employee type" column/list that contains the choices "FTE" & "Contractor" and an additional column/list that specifies the type of contractor as "long-term" or "project". I now need this all in 1 column/list. Is there a way to convert all this into 1 list without doing it...

How do I break up a cells that contain people's names? The cells contain FirstName LastName and I want each name in separate cells (for sorting purposes). Some of these cells also have names with a middle initial. I am totally lost so any advice will be helpful. Thank you in advance. Lew

I have a drop down list that I have been using but I need to add a few more choices. I have already selected all the choices for hundreds of cells and I do not want to redo them. Is there a way to add to the list so the additional choices appear without having to redo all the cells? Thanks...

I currently have a column of names(first and last), some are all caps, some are both caps and lower case, some have a middle initial with a period, and some don't have a middle name at all. I'd like them all to have the first letter of each name capital and the rest of the name lower case so...

I used to know how to do this but I havent done it in years. I have a column with peoples names and each cell looks something like this "Smith, John" (no quotations). I want it to look like "John Smith" but I'll take it if I can have the first and last name in separate cells. I just forget...

Hi All, I was wondering how to hide the majority of cells in excel. I currently have a spreadsheet where I only need to see up the "K" column and down to row 51. I would like to hide every other cell except this section of the spreadsheet. I know how to use the hide option, but it requires...

I was wondering if there is a way to group multiple tasks which have the same start and end dates. I want to be able to group them and then link them to the next task that starts at a later date. Also, is there a way to link 2 tasks in which the 2nd task's start date is in the middle of the...

Is there a way to have a slide's animation only animate once, the first time the slide is viewed. I will be walking through a slide that requires a great deal of animation and revisiting it multiple times after. I would like the animation to appear only the first time I view the slide and no...

I am developing a training program in PowerPoint and would like to include a jeopardy slide. I was wondering if there is anyway to make the slide interative. I would like to click once on the dollar amount selected by the participant to display the question. I would like to then click again on...

For my application I would like to add validation so that when a user enters a start date, the end date will automatically calculate and generate in the "Week End" field. The week end date will always be 7 days later. The problem arises when the user enters a starting date that is at the end of...

I currently have a button that allows a user to add a table. When the user click the button, a copy of the (blank) table is displayed directly below the original. Each table has a unique ID and increments with each addition (idTable_1, idTable_2 and so on). As each table is added I need them to...

I have recently broken a large web page apart into 3 sections using the <div> tag. The user clicks the next button to move on. However when each of the 3 pages load they start at the bottom of the page (focused on the next button) and you must scroll up to see the top. What is the easiest way to...

I am trying to allow a user to click an "Add" button and have an instance of the current table appear directly below. The addition table should be blank. The table allows an employee to create a correction to a timesheet for a given week but they may need make a correction for more than one...

I am creating a web application that requires the user to enter an amount for each day of the week. The numbers are entered into text boxes. I need to have a running total of all the numbers as they input each number. I am using the onchange event handler so each time they move off the boxes the...

I am trying to validate a very long number. Its more of a code but I need to ensure that it is positive and was entered. The number would look something like this 0012.567.984.01 or 112.345.33333. The problem I am having is that if the user enters more than one decimal point it it is not...

I am fairly new to javascript so I am sure the answer is simply, but when I run this function it only runs through the first IF statement and stops. I have tested this with an alert() window. When the user clicks the submit button I want to validate that each field was completed. Could someone...

These questions pertain to a spreadsheet with thousands of ID numbers.... 1. How do you check to make sure a number is 6 characters long and add zeros to the beginning if it is not? 2. How do you check to make sure there is not a space before a number and remove it if there is? Thanks, Lewis

I currently have an excel file with thousands of employees and their employee numbers, both in one cell. Formatted as such, John Doe - 12345. I need to create a new cell for the employee number for the database I am creating. I know their is a way to extract just the number rather than copy and...

I currently have a fairly large table with many cells. I was wondering if there was a way to auto-fill the borders of each cell rather than using, <td style="border-right-style:dotted; border-right-width:thin; border-left-style:dotted;....(and so on)> for each cell. This is very time consuming...