hi community
can anybody please explain to me...
what is the real usage of the "Justify" in the Fill icon under the Edit
Group at the Home tab (excel 2007)

not seeing what missing, trying to make the following:
=AND(NOW()>"16:00",$DR$3<"16:00")
where Now()>"16:00"  seems to return the opposite of the actual time.
if 17:00 is the time, I get a FALSE.  is there an error in my example?  

I have amounts in a row formatted as USd and AED.Cell A1 200 AED and cell A2
$200.I need to differentiate these two and I should able to capture the USD
alone.The idea is to seperate all the USD.Filter is not working.Please advice.

I operate a football pool for the season (approx 140 entries)  Briefly, here
is what it looks like;
Current      Name     Total points    Week One    WeekTwo    Week Three   ect.
    1          Joe               35                  11               13    

Hi, I am using the Comments facility in Excel 2003 - often when I type in a
comment, then click out of it, I find that half of the wording is hidden and
it necessitates me going back into it to resize it.   I think there is an
automatic sizing feaure somewhere (??), but the time ...

I want to print sales order forms to use when selling goods.  I already have
the template created.  I would like to print the template with a unique
contract number that will iterate by one each time the printer prints the
next copy of the sales form. i.e. If I print 30 copies of ...

I have data files with the names based on dates ordered such that they
naturally appear in order:
Acct 2007-07-23.txt, etc.
In my spreadsheet, i search for complete data and when I find that I am

I'm having trouble with using the "A-Z" sort button from the toolbar.  I use
these buttons all the time, and I thought that as long as I was in the column
I wanted to sort, and that the data was formatted properly (i.e., contiguous,
no blank rows/columns, no extraneous text in ...

If I have a worksheet where all the column widths are relatively
small, so that I can't see all of the column header value, and some of
the values, is there some sort of shortcut that can quickly expand all
the column widths so they become as wide as the widest value in the

Hello DLW,
That works for my numbers, UNLESS the first number is a 0 (ie. 098 returns
as 9 | 8 | 8.
It's possible that I have to make it a text.. but when I tried it still

I am using auto filter to get rid of columns where there is no infomration.
My problem is, that in another column I need it to just count 1, 2, 3, 4 etc.
once it is filtered. Does anyone know how to do this?
Thank You,

I have multiple randomly named contracts files in a folder(saved as Customer
name, last name,first name).  They are placed in this folder based on cell
data for the month the contracted work is scheduled (masterU3).  What I would
like to do is extract the dollar total for each ...

One row has a lot of data in one cell, but it cuts off the data in the middle
and doesn't show it on the spreadsheet or in print, except if I hit F2.

I am trying to set up a payroll spreadsheet for our HR department. We have
roughly 30 locations within the company. I created a template time sheet for
all 30 and I included about 10-20 blank columns for each company (for
growth). All of these spreadsheets are linked to a master ...

I have an Excel file with four pivot tables that are fed from an Access
table.  The Excel file is now 160+ megs.  Zipped it's over 30 megs.  I've
tried all the recommendations I've seen in the postings regarding deleting
unused cells, copying the pages into new files, etc., and ...