Excel 2003
My really be a "data" issues not a vlookup issue - but here is the problem;
1st column of my table_array:
149255

I would like to use conditional formatting to highlight those cells
containing calculations.  It appears that conditional formatting only
allows you to format cells that have specific results (equal to,
greater than, etc.)  I just want to be able to visually distinguish

I have a column of dates (assume A1:A45) and I would like to highlight the
first date in the column (reading top to bottom) that is equal to, or
nearest to a specified date (in Cell B1), but NOT less than the specified
date.

I have just installed Office 2007 and I am having problems finding the
options that used to appear on the Tools tab in Excel 2000. Can any one help?
Thanks.

I have a 5 column table that I convert to a simple one column table, which I
copy and paste in an email.
I do this to simplfy and ensure compatibility.
The columns are: Code, Account #, Value, Name and Account type

how do u sign up for a product key

I have a sheet with a large number of formulas. A sample of these formulas
is:
='June 2006'!E$160+'July 2006'!F$160
Is there a way to change from relative cell reference to absolute cell

I have a need for data validation in which list entries are reduce when used
anywhere in a pair of rows. However, each entry in the list should remain
useable in the following pair of rows until used there, etc, etc.
Example

I have search all the web but still cannot find a solution to this problem.
I have a single cell containing the number -> 12345
I wanted to either separate the number 1 into column A, 2 into Column B, 3
into Column C and so on.

I have a question regarding lookup
I have a customer list with all the customers with their addresses.
I have another list with only the first name of the customers.
Now I want to look up the name of the customer of the second list in the

I have a spreadsheet where I embedded a chart on one of the worksheets. I
recently modified the worksheet (nothing in the chart or its associated
data) and now the chart is grayed out unless I select the chart object. It
prints grayed out, so it's not my video card.

if I send an xlsb workbook ( Binary ) by using the Send To function the
resulting attached workbook seems to be converted to Compatibilty mode ( xls
), BUT the extension of the attached workbook remains as xlsb, resulting in
the fact that people can't open it directly. Is this a ...

I'm using XP and Excel 2000.  I'm not a sophisticated user.
My word wrap is functioning in some cells but not others.
I imported a text document into a new worksheet.  In the process, I chose a
format for each column as some are numbers, dates or text.

Greetings!
How can I validate the cell value like 123.12345 or 123.12345.123 or
123.12345.123.123? The numbers can be different.
Thanks.

I'd like to make so that whenever I create a new document in Excel
that the "Page Setup" is set to scale of "fits to 1 page wide by 1
page tall".
I'm sick of creating a new document and always having to go to Page