I have two worksheets
Worksheet 1 has a summary of data that is gathered from worksheet 2
(detailed data)
Worksheet 2 has the date in the A column and data for each day in

I am using this look up to insert a cost into column I from my value table.
how can i get a description inserted into Colunm P of my spreadsheet. I tried
changing costing to discription but it just gave me #name
=IF(I13<1,"",VLOOKUP(I13,Costing,2,FALSE)*J13)

Is there any simple way to convert text in Excel
19721221  
to:    12-21-1972  ?  
We are often sent birthdates in the top format and HAVE to have it

I am interested in doing a count of entries within a cell.  It would be
similar to a word count, but instead of counting words, I need to count the
plus signs (+) or something like that.  I have a simple formula in the cell
like:

I have cells that contain text and numbers.  How can I pull just the numbers
out into a new cell.  I would use the Right or Left function, but as you can
see from below they are different lengths.  Does this have to be done in
Access?  If so, how?

I am doing a spreadsheet with several columns...I want to sort the rows by
info in a certain column...I want each rows' info to stay in line while i
sort by that certain column...can this be done? Also more than 1 column
contains numbers and the column I want to sort by contains ...

Using Excel 2007, I created a pivot table and where I grouped a date
field by Days and set the Number of Days as 7 (essentially grouping it
by weeks).  Here is an example of what shows up in the table:
12/2/2006 - 12/8/2006

I need to automatically set the font of comments without having to manually
change it.

In using office 2003 and playing with advanced filter.  When I run it I am
getting :
'The extract range has a missing or illegal field name' error message.
All the columns have field names - cant find anything on MS other than for

I have a work sheet with more than 300 customers in rows with sales volumes
posted in
month wise for the last 3 years (Apr, May, June etc.,).
I can attach the sheet for your ready ref.

I would like to use the same sort order for a specific spreadsheet every
time.  Can I set a sort order that will display the same every time I select
the sort function within that spreadsheet?
I am using Windows XP and Microsoft Office Excel 2003.

Hope this isn't a dumb question...
When I exit a workbook , Excel is asking me if I'd like to save changes
, even when I haven't made any!
Sometimes I have several open and it's a pain to be asked this for every

I have read different questions, but I have not see the solution to my problem.
I want to validate in one cell if an valid E-mail address has been entered.
With Date validation->Allow custom, I entered the formula (B5;"??@?.?")
So I want a value like "freek@mvp.com"

Hello,
I have a huge workbook and somehow I saved  2 identical copies in the same
file.  The file name changed to New Vendor Schedule Master Version 2.xls:1
and New Vendor Schedule Master Version 2.xls:2.  When I look at my file name

I'm setting up a table for my DVDs, Title, Actors, Notes. In the Notes column
I have to go to Format, Cells, Alignment, Wrap Text. Is there a way to wrap
text automatically?
TIA