In my account sheet I need to have dollars in the first column and cents in
the second. For my total row I would like to be able to have everything sum
(dollars and cents) and then be displayed as it is above (dollars in the
first column and cents in the second) How in the world ...

I’m using a dropdown list with names listed, once the name is placed in
any field it may not be selected again.
Can I automatically check for double entries and indicate as such?
Or perhaps eliminate the names from the list once they have been

I am trying to calculate the difference between two dates and have that
diveded by seven, (e.g. 7/XX-XX) and remove any answers that sum less than 0.5
So far I have the below formula, but it returns an "ERROR" where there is
blank cells. I think that is because of the zero in the  ...

I lost the datea for a file A that is replace by different daya in one sheet
and has the same fle name A .  How can I retrived the original data in
diffferent sheets that I labed File A.  I looked in the recycle in as well  
as Start-Search-file name and could not get the file ...

I currently have a spreadsheet of ithousands of investment data recods that
each have specific criteria:
Examples
Fund- 1,2,3, etc.

I currently have a spreadsheet of ithousands of investment data recods that
each have specific criteria:
Examples
Fund- 1,2,3, etc.

what formula would you use to calculate current age given the birth date and
current date in the worksheet

How would I display the word "Paid"  if the value in another cell in the
worksheet had a value greater than 0?

I can't get the fill color to show up on cell tables. If you do a print
preview the colors are shown. I need the colors to be shown when working on
the spread sheet.

Is there a worksheet function that will copy (or return) the value of
another cell (not its formula), with the result being stable, even though
the orriginal cell was volitile?
=VALUE(B3) will return the data but it remains volitile.

I am trying to use 2 variables with the SUMIF function. ie:-
sumif(<range1>,<criteria1>)(<range2>,<criteria2>),<sum_range>
So far, I cannot find out if this is possible. Has anyone tried and managed
to do this successfully?

I am trying to show all Formulas on my spreadsheet, but the "Ctrl + ?" is not
working for me.  Where is the accent key on the keyboard?  What is another
character on the same key to identify it with?  
Thanks

heloo
suppose that i have 6 coloumns as follw
1    2          3        4   5      6      
i want to change the font color of the third and forth column  to red

Sheet 1:                                              Sheet 2:
               week  # of     avg                        Store      week of
               of ad   stores  sales        Region      #        act. sls  
act sls

I have set up a spreadsheet which required data from another spreadsheet and
want to know how i can set this up to update every time i open the sreadsheet.
I want the full page of the source data copied accross to a worksheet in my
main excel file.