I have a cell, F5, that has 20071225 in it. I want to convert this to a date
field that displays as 12/25/2007
When I use the function =DATEVALUE(F5) , I get #VALUE!
Can you tell me how to do this without using substringing and concantenating

Excel 2000
The formula =IF((FIND("Overall",B2)),"Y","N") produces a Y if the word
Overall appears in column B, but instead of an N if it doesn't, a #VALUE!
appears.  I've tried "", false and leaving it out - but the #VALUE! always

Anyone know if you can use the "record macro" function to record the creation
of a pivot table?

I want to make an email hyperlink that includes text and a cell value in the
subject line, like this:  Status Change [Data!A1] .
Is there an easy way to do this or do I have to VB it?

When i select a column and then select "Hide" in the window toobar, the
entire workbook is hidden.
I only want to hide the specifiic cell, how do I accomplish this?
Swiv

I have a person I work with who had an Excel sheet that has about 40 tabs
with roughly 200 rows in each tab.  There are some cell that get information
from other tabs using =tab name, cell.  The file size was 3,278 KB.  She made
some changes to this file where she added about ...

I have one file that when I close it, it always asks me if I want to save
changes, even if I didn't even breathe while it was open. What gives?

I have a list of cables and with beginning total (length) of each one.
throughout the year, users are filling rows with type of cable and the
amount they took or received to the warehouse. (Headers: Cable Type,Income
Amount,Outcome Amount).

Hey guys!
I have 2 columns of data. In column A is my master list of names and in
column B is a list of names that I would like to compare against my master
list in column A. If the name is found in column B that exists in column A,

Hi
What do you recommend as the best way to create a custom number format for
any number I enter in Excel and be able to apply that number format quickly
on any new number I enter in any new Excel file I create?

Am using Excel 2003.  I am trying to count the number of zip codes in a
column.  I have already copied and pasted the zip codes into a separate sheet
in my workbook.  I need to know how many 12345 zips, how many 12346 zips,
etc.  So I want something like this as a result:

I am trying to utilize the sort function to sort multiple columns while
maintaining a  grouping of cells.  My need is to eliminate blank groups of
information and maintain the grouping of the information.  The cells of this
spreadsheet are set up to reference different tabs ...

Insert row at each change of surname in column

I have a groupd of cells.  I would like the value of a cell reflected in
another cell based on a cell's highlighted color.
Col1    Col2          Col3
45       Yellow       if Col2 is green then Col1

Hi to all!
I've got a question: Is it possible to move, change size... images inserted
with the design mode?
The problem is this: