If I have a cell with a digit 123,4567 - how can I copy the content of the cell to another cell with only two digits after the comma. In other words - I only...

I have information in column A of a task sheet. The information goes from row 1 thru 35. Column B is where I place a "x" to say the task need to be...

Hi, i have a table like this: john 4500 john 1200 mary 900 jim 5000 john 3700 mary 2300 jim 1400

I have a spreadsheet with several hundred rows and many columns. The formula in column "C" sums values for all columns from "D" through the last column for...

I need to know how to create subtotals for individual pages in excel. The user has data each month consisting of hundereds of rows. Is it possible to have...

Hi there, I've got a list of products for my company but it is listed in product group, the products for that group coming underneath.. like...

Hello, I use a spreadsheet as a calendar with a separate sheet for each month. I have the days going across the top and a list of staff names down the side....

Guess I have a duel question. First, I have numerous columns of data, all numerical. New entries are entered at the end of the column. Is there a formula...

I know how to arrange windows to look at multiple workbooks. But I want to have two worksheets displayed at the same time from the same workbook. Is there...

Hi Lady Layla I have the same problem as Jeff in PA. I cannot seem to be able to select the data in my Excel file asn then name the cells to create the...

Hi Community of Excel Users! This is a joint posting from 4 of the "regulars" to these newsgroups: Bob Phillips, Frank Kabel, Ron de Bruin, and Norman...

when i open excel. WPEXCEL opens up first. How do I stop that from happening? Thanks

I have a certified payroll spreadsheet in which I want to display only the employees that have pay data entered that week. I often unhide all rows, enter data,...

I have a blank column A and a second column B with different alpha-numeric 17-characters in cells B1 to B50000. These are vehicle VINs. Now, when I enter a...

Hello, I have scoured the newsgroups and searched quite a few posts for what I would like to do. We will use cell R3 as an example. I have Office 2007 and I...

Hi there I have a spreadsheet with a SUM formula in Column k. Example K3 formula is =Sum(D3:I3) I clicked and dragged this formula all the way down to K...

Does anyone have any suggestions on how to set the default format on excel 2003? such as font, size, center align, whenever I open, it is all set. Thanks in...

Thanks. That worked great! -- Matt in AZ "Max" wrote: Try this .. Assuming the data in cols A and B are in row1 down

I am creating a questionnaire, where there are yes and no questions that have radio buttons next to each answer. I have two questions. 1. Currently I have...