A database query program outputs everything as a text string.  One of
the fields is a date, formatted as yyyymmdd.  Is there a worksheet
function that will change this to an Excel-recognized date?  Or a
macro?  The error checking doesn't flag this.

Thanks to everyone for the ealier input on this subject.
i am trying to find out where i can either purchase, commision or  learn how
to make a security com add-in. to password protect my excel file that cant
be craked with a $40 piece of software

When I start Excel 2007 a couple of files load at startup (Common
Macros.xlsm and Personal.xlsb) both of which contain macros.  Everything has
been working fine for quite a long time but today I get "Compile error in
hidden module: This Workbook".

      I am very new comer in excel VBA programming please send me the
VBA code how to change the cell color to text value.
Atul

I'm using Excel 2007 on Windows Vista.
I have a decription in column I like "S/back 2.0 TDI SE DSG  " and in
column Q I have the formula FIND("DSG",$I2).
Looks simple enough to me but it isnt bringing the result I want! Just

How to use a certain row to be as a header on each page when printing?
thanks

I have a spreadsheet with 7 columns (named Bird, Cow, Horse, Rabbit, Pig,
Cat, Dog) and 23 rows that have either yes or no in each cell - mainly no's.  
If there is a 'yes' in Bird then there should be 'no' in each of the other 6
columns (Cow, Horse, Rabbit, Pig, Cat, Dog).  ...

I have a column of cells with information in some of the cells only. the
information is text with numbers (the text can be of varying length), for
example: C3 could contain: 1 avml 12 chml 1 special occasion.
There could be as many as 12 variations in the string of text.

I have a question regarding replacement of a character with tabulator.
I have to replace "-" with tabulator for one column. The column has
several words separated with "-".
Looks like this: SFS-HV-AFS

I am looking for a spreadsheet that I can enter product codes and sales
quantities that will record and calculate daily sales averages.

I wish to find specific information within the following string of
numbers that is always different.  Here is an example of what I am
looking for:
Where to look:

I'm trying to create a simple inventory control spreadsheet consisting of 4
columns. Name, Transfer In, Transfer Out and Current Stock. I need to be
able to put entries in Transfer In, Transfer Out, hit a button and have the
Current Stock updated accordingly where Current Stock = ...

We use Office Excel 2003- We need to insert data from preset column B in
Spreadsheet 1 to "new column B" in Spreadsheet 2 (downloaded data in Col A,
but new Col B created by us). Thus, the formula you advise for cells in Sheet
2 column B, need to produce the result x=Medium, ...

Is there a way to convert a table now set up in Word, to Excel? I can't find
it in the help screens (only converting the other way....)

I want to send a blank table in outlook (not an attached spreadsheet) that I
could ask the recipient to fill in and return to me by email and then
transfer that directly to a spreadsheet without having to enter data again
manually.  Is this possible?