Recent content by PepeLeMokko

Don't know if you read my answer... Was it of any use ?

I suppose you need those figures as a text string, so when you enter the figure preceed it with a " ' ". That will do the trick

Please check this link : http://www.cse.bris.ac.uk/~ccmjs/access97_and_2000.htm

Locate the Excel.xlb file from your user and copy it. Rename your own Excel.xlb file and paste the user's file in the same directory.

Mat, you could also proceed as follows with your existing data : If data is col A, put following formula in cell B1 : =IF(ISTEXT(A1);DATEVALUE(A1);A1), pull down as needed ( double-clicking on the handle in the right low corner of the selected cell will extend the formula automatically as long...

Well I would suggest you use the Tables for your problem. Results will be the same and Tables are ever so flexible :-D

If you are using tables, go to Tables-Tables properties - Row and check "Allow rows to break across pages"

To follow Tony's answer up: if you want A1 to display the contents of B1 : record a new macro ( tools - macro- record new macro)and do the following : right click on B1 KEEPING THE BUTTON DEPRESSED, move the pointer to the upper part of the selected cell and drag to A1. You will get a nice menu...

Select the column or click a cell in the list you want to filter. On the Data menu, point to Filter, and then click Advanced Filter. Do one of the following. To filter the list in place, similar to using AutoFilter, click Filter the list, in-place. To copy the results of the filter to...

aleahim,take a look at the functions offered by XL ( I am using XL 2002) in the " math and trig " category and check the MINVERSE function. Hope this helps Pepe

There is also a built-in function for this in XL 2002. This is the EDATE function [2thumbsup]

Also look at the possibility of making a Pivot Table using the multiple consolidation ranges option in the Pivot Table wizard.

You can add all the adresses to a group in a personal distribution list ( say the group's name is " group") and when you send your newsletter, just send it to " group". All the recipients will then receive the mail. Via the address book you can manage " group&quot...

Another trick to distinguish real dates from text is that by default text is left aligned and dates, as numbers , are right aligned

This is for XL XP ( see the Help menu..) Filter for unique records Select the column or click a cell in the list you want to filter. On the Data menu, point to Filter, and then click Advanced Filter. Do one of the following. To filter the list in place, similar to using AutoFilter, click...