Alrighty, what I have is an original workbook that runs a heap of
different IFs and LOOKUPs and fills out a template.
The filled out template has to then be emailed off to people, but
without them having a copy of that original workbook that fills it out.

How can I preserve leading zeros in a cell?  I'm entering equipment serial
numbers in cells, but any leading zeros are not displayed. I do have the
Zero Values box checked in Options. Thanks in advance. -Hank

Does anybody has Attendence excel file which i can use for tracking
attendence.

I have a work sheet in which i have to look for word "Test" and color
the rows below it.
There are different words like "Test 1"  "Test 2" and each set needs a
different color.

Could some kind person check this for me and tell me where the error is in
this formula please as I keep getting that dredded error message "This
Formula Contains An Error
=IF(OR(AB13="",AF13="",AH13="",AJ13="",AT13="",BG13="",BT13="",BY13="",CA13="",CE13="",CG13="",AB13="N" ...

Hi, I am having a memory block !
I need to sum costs in colum C, if column A = x and column B = Y.
n
When using sumif i appear to count all costs in column C not just the ones

I'd like to protect certain spreadsheets using the Excel 2003 built-in
encryption.  Just on a hunch, I Googled Excel Encryption, and discovered a
variety of programs claiming to be able to open any such encrypted files,
regardless of password complexity.

I have a spreadsheet  "C:\myWorkbook1.xls" with a named range
"mydatabase"
mydatabase range spans a1:C4 and contains the following data:
Name  Age Address

Lately whenever I start Excel, Zone Alarm informs me that Excel is trying to
access the Internet. I checked the "startup" folders in the Office
installation folder and there is nothing there.
Thanks in advance for any help.

I have an IF formula down column F, and am trying to read the results with
another IF formula in column G:
=IF(F5 > 1/32, "Yes", "")
But the formula in column G gives "Yes" when the cell in column F is filled

When I try to get into my Email, I get this 404 error. I am new at
trying to solve my own computer problems and would really appreciate
some help.
Taco

Example:
Column 1   Column 2   Column 3   Column 4    Column 5
1                 9              09A1         0023           delete
3                 11            11D4         1057           revise

I need to calculate the percentage of a number in a specified period.  Can
excel calculate a percentage of an occurence?

I have an array of data where some data may appear multiple times
throughout the array.  I am trying to find a way to locate the next
closest instance of a given value in an array, recognizing that the
value may appear multiple times in the array.

With ActiveCell
    .Offset(, 3).NumberFormat = "Text"
this fails - runtime error 1004, unable to set NumberFormat
    .Offset(, 3).NumberFormat = "General"