Does anyone know how to convert a date into a single number so that you can do calcuations with it? For example, Nov,2005 minus January, 2004 equals 23.

Im sure this is a real simple thing to do, but I wasn't able to find anything using the forum search. This is probably because i don't know what I am trying...

Hi all, I am trying to find out whether it is possible to password protect a worksheet within a workbook. I have 3 worksheets in my workbook and want to...

This is wrong. The number you are looking for is A1-(A1/1.07) NOT A1*7 "Paul B" wrote: Your welcome -- Paul B Always backup your data before trying...

I am altering REPLACE functions for different parts of my data. This works OK, but it would be more efficient if I could apply one function to all of my...

I would like to put a short name like "BILL" in column C and have it return a whole block of preentered text about Billing. I need a validated Lookup where I...

I am setting up a database that will show me how many wrong entries have been made onto our server. Each row will have info regarding the entry and the last...

My Data Table looks as so. Products across Row1 and Salespeople down ColA. DataTable A B D Z 1 100 500 100 99 2 50 200 100 200 6 0 500 100 99 10 0 0 100 0 I...

My database has columns headed with food sales, bar sales, net sales, etc.. The rows are numbered by day of week, with the day of the week in the next column. ...

The current date and time pulls but it does not specify am or pm. How can I write a formula that will show the current time as am or pm?

How to keep sheets displayed(arranged) when moving between them?

Hello group. I've delved into the acrhives for this topic but haven't seen it specifically addressed. I have two columns of values ("E" is 480 rows and "J"...

Pls. if any one has any info.. I ve worked out and cleaned up a macro to automatically import external data from multiple sources,lookup and match table...

I have a Excel Spreadsheet that keeps up with my stock purchases. I also have set-up a chart to graph my progress. What I want is for a macro to take the...

There has to be a way to hold the numbering format in excel spreadsheet when it converts to data source for mail merging. Help!

I have a range of prices in column A. In column B, I put a check next to what I'd like to order. The bottom of Column A should only total values that have a...

Hi, I have a worksheet in excel and column A can have the value 'Yes' or 'No' I want to copy the excel to powerpoint (using paste special, paste link,...

HELP!!! This may be a basic question, but it's giving me trouble. I'm trying to set up a worksheet where by inputing a value in a cell, it changes the value...

I inherited a workbook that has a link to another workbook that no longer exists. Every time I open this workbook, a message pops up that it can't find the...

How to link cells so that if one is not answered then the other cannot be filled...