Hi, is there a formula to convert kilo's into pounds? i can convert simply multiplying the kilos by 2.2 and dividing by 16, but this gives me 'decimal' answer...

I have 4 columns which I have set up with a formula to calculate percentage. The 4 column formulas should equal 100% but they equal 106%. Can you help?

Does anyone have a solution? Subject: If statement From: "Doug" Sent: 6/25/2004 5:42:46 AM The format category...

I want to be able to select from a list based on the contents of another cell. For example, in A1 I can select the value from a list of 4 options. Cell B1 has...

I am trying to fill in an amortization years column. The first 12 rows are "1", the next 12 rows are "2", the next twelve rows are "3" and so on. I've got...

Super expert, If I have cell containing a series of data like this .... 1,12,9 1,2,9 1,22,17,18 23,23,1,9 24,21,1 1,23,11

This is my first question on this site, so I hope I hope this makes sense. I have vendor numbers in Col A-each vendor number would only be listed one time...

I have been working on this for a little while now and can't seem to grasp the right formula to use. I have columns of data sorted by name to be tracked...

In lotus, a print button could be defined on each spreadsheet within a file. So when I wanted to just print spreadsheet "A" I would click on the "print" button...

Anone one got any ideas on this? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet...

I was so impressed with the wonderful responses and spot on answers to my first question on this site I thought I would give this one a try. I did try to...

Hi all! I have an Excel 2000 spreadsheet in which I'm trying to use Data Validation to restrict entered values to a List. The List is hard coded on the...

Does anyone know how to set up the same print title on several pages on several worksheets at once?

When I open a worksheet, created in a english version of=20 Excel, which have a button attached to the=20 macro "auto_open" The swedish version of Excel...

Howdee all. I received some help from T. Valko back in January on a complicated worksheet function. It's been working really great, and today I found that I...

I need to create several different pivot tables from the same set of data. However, I need to keep switching between the different tables and it quickly...

Hi, see table below. Col A Col B Col C a 1 7 s 4 9 x 8 4 d 9 3

Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest...

I have 10 columns and 5 rows of cells. All cells do not contain a number and the cells which DO contain numbers are sometimes 1, 2, or 3 digits. I need to...

I am using the same range for a number of pivot tables. If I add to the data, is there a way to update all of the tables at once? Right now I need to update...