I have a formula for identifying years, months, days from a past date to
now. DATEDIF(C6,NOW(),"y")&" Y, "& DATEDIF(C6,NOW(),"ym")& " M, " &
DATEDIF(C6,NOW(),"md") & " D"
I'd like a formula that can produce the same format (years, months, days)

I recently tried a couple of solutions I found on these boards to
ensure that the Task Pane stayed visible on startup.  I had already
tried setting it in Tools|Options, but since I have both a Personal.xls
and a Book.xlt, I tried the registry dword approach.  It worked on the

I have a bunch of workbooks that all used the same template and were filled
out for each week of the year. They all have a "totals" sheet the collects
all the important data within.
What i want to do is create a macro that imports that totals page, or a

We want to start allowing our users to have ODC files to connect to and look
at data in SQL SERVER VIEWS.
I want to make sure that the users will only ever be able to look at this
data and not actually change the back-end SQL data.

I have several books that are all in the same folder (master templates)
I'd like to link them with out recording the "full path", that way I can
copy the files to "project" folders and use them. But I don't want them
pointing back to the files in the master template folder.

I am encountering a really strange issue with standard paste in excel. Here
is what I do and the strange behavior I observe:
- I copy from excel a single line containing some blanks inside
- I open notepad and paste the line into it

The text of my document is getting cut-off, especially the letters g and p.  
I am using CG Times, font size 12 with a row height of 14.5 in Excel on MS
Office 2000.
Any tips on how to get it to stop??

B55 calculates the difference of two values
B56 calculates square root of B55
I want to set B56 to zero if B55 is negative.
How do I do this?

Here is the situation.  I have a workbook, where each worksheet has
pricing data for each state.  On the "state" pages the format is
the same.
                       1-3.9 inches    4-7.9 inches    8-11.9 inches

Ok well my goal is to start out by using the DateAdd function to add
the number of months in column F to Colum H and comare it to Column I.
If that date is < the Date in Column I, then copy the data K of the
corresponding Row and paste Starting in colum M of the same row. If

How can I import an Excel database into my Yahoo! email address book?
I created a rather large database that has a lot of email addys, along
with a bunch of other fields (e.g., name, address, postal code, etc.).
Anyway, I would like to import the names and email addys into my Yahoo!

I have MS Office 2000 Small  Business. How do I get the Microsoft Excel Help
Task Pane to work,when working in excel?

I haven't been using excel for that long and all of the sutton I get a black
square box instead of my normal curser and I don't know how to get back to
the normal curser.
Please help me

After using conditional formatting on a column, then changing to view
functions in cells (CTRL + ~), and then going back to view values, cells with
a custom date format (3rd from last in the list), show up only in the
function-view format of miliseconds.

1)       i want 120 to one hundred and twenty only                          
          2)    120.50 to one hundred twenty rupees and fifty paise only
these are the 2 quest pls help me