I have one column with a "beginning date", another column with "ending date" and need the formulat to calculate the number of day difference between the...

I know how to link two workbooks together, but here's my dilemma: when it links, i want it to sort the information from the column so that let's say i have six...

I'm experiencing something REALLY wierd. I'm a VERY experienced EXCEL user, and I've just installed the Excel 2003, and I am having the Da**ed-est of times to...

Is there any way to unhide multiple worksheets at one time. Currently, I can unhide a worksheet by clicking on Format, Sheet and Unhide and then double...

Given the list of text values in column A below, how would I construct a function to count all the unique values that start with the text "A1001". Using the...

Using 2000, is there any way that I can change the format of a worksheet tab?

Utilziing Excel 2000 (9.0 SP3) is there any way to format the appearance of a tab name?

Hi, Is it possible to concatenate a carriage return (ALT Enter)? I want to take three cells and place them in a single cell on three lines. Regards, Tim

I have a spreadsheet which tracks locations of parts. The location is in test format. I want to add up the total of each location to a numeric value. Any...

I'm trying to complete a billing sheet, and I can't figure out how I could type a number in one field, and it will copy to several other sheets. I.E. I type...

Does anyone have a function to convert numbers to engineering notation. After converting for instance 10000 to 10k I was going to use the format command to...

Hello and thanks for your input, I would like to have a cell formatted with a box that when the user clicks inside of it, the box becomes populated with a...

Is there a way that you can have a custom number format so that the figures are displayed as Hours Minutes Seconds Frames (25 frames per second) The nearest...

Can I access the list of holidays Excel uses for this funtion and change the list? Thanks

hi there... i want to do EXACTLY the following i created a customized sheet and put it in C:\Program Files\Microsoft Office\Office\XLStart but excel still...

I have a spreadsheet that has 12 months, Jan-Dec. Inside each month is each day of that month. Also have a list of items that are available for sale each day...

Excuse me if this is too simple for this forum but as an old Lotus user and now retired just want to know how to change say a list of 10 items in A1..A10 to...

I have a long list (33,000) of items and have the list sorted based on category 1 and 2. Is there a way to quickly go to the last item in categrory 1/first...

hi, i have a spreadsheet with about 4 columns of data. while recording a macro i deleted every cell in the 4 columns of data. i then had a button and i assined...

If I have a column that consists of "yeses" or "no's," how do I count the number of "yeses" in that column and the number of no's in that column.