Hi friends, i have a small query if you got little time. i have many numbers in an excel worksheet and i want to round them up only for decimal places and...

I thought someone might learn something from my post: http://michiel.wordpress.com/2009/04/05/10-worst-microsoft-excel-practices/ Michiel

I want to fill a standard size paper with 100 equal squares

i have a column of numbers that I am pasting into a worksheet and they are 13 digits. i just need they listed as they are no funtion to them(mathematical). ...

Is there any way to open Lotus 123 files in Excel?

I work for a charity. We have an agency which collects new donors for us. On a weekly basis, this agency sends me a spreadsheet file containing data about...

Hello, I am working on an Excel course from OzGrid. One of the problem/examples defines the MATCH function Array as 1:1. In my ignorance I expected something...

=IF(O141000000000,"DUAL VP",IF(O14500000000,"VP", IF (O14100000000,"AVP", "OFFICER"))) I what above condition to be true only when Cell A1 is selected...

I entered a row into a template sheet. Where there should be 1 cell there is now 2 cells in one of the rows and when I drag down to auto fill, it is...

I was wondering if it was possible to use 2 criteria for a count if formula. I want to count the number of numbers in a range that are above 0. I would write...

Are you sure that you need all those decimals in the original worksheet/workbook? If you don't, you can round them (or truncate them) to the proper 2 decimals...

how do i get a total for a list of names entered in ie alan billy chris dave ...... also is it possible for the date to be automatically enterd in each...

Hi I run Win 2K with Excel 2K Question 1 I have some VB code in the "Sheet 1" module of my excel file. The code is as follows:

In one cell in the SS, I have a comma delineated group of numbers eg 23,4,5,36,2 Is it possible to determine that another cells contents resides within this...

hey, im making a timeline plan for school, and when i enter the date such as 3/2/06 it autocorrects it and changes it to 03/02/2006 which i dont have enough...

Hi i have 2 questions on how to do things if anyone could help it would be great. I need to create a text box and a button where when you enter a number in the...

I followed most of the post recently on the subject of list and combo boxes. From what I can tell I need to create a list but I need to have the list find the...

If I have the following data A B C 1 Personnel group type p't number 2 Melinda ...

Hi friends, For the past few months, everyday I have to download 3-4 files from my banking site and I save those files in *.xls file format. But when I open...

20,000 Computer Tips n Tricks for detail visit this site : http://www.computertipsntricks.info