hi, I am unable to use HEX2DEC function, i think a plug in is required but
cant find it. can anyone help me with that. i am using excel 2003 XP

I'm trying to pull into one sheet, the values from the same 10 cells in
about 500 spreadsheets all stored in the same way.
Using =CONCATENATE() I can construct the formula which correctly
reference each cell in each file (all date named files), also using the

I have a large worksheet with numbers already entered onto it, as positive
numbers, however, I want to change all these to minus figures.  Is there an
easy way to do this rather than having to change each figure individually?
Thank you.

I have 5 columns of data (please see attachment). What I would reall
like to do is to only add up the data in the 4 columns that are betwee
2 dates. For example, I would like to specify that all numbers in th
'calls made' column that are between 14/09/05 and 16/09/05 in the 'dat

have had kind of help with this before but i need more.
i have a name that i wish to find if it is within range (range name =
"Names").  If that name (say George) is within that range, then I wish
that name to be entered into the cell with the formula.  if "George"

I'm working on a work schedule. I would like to put two numbers tha
represent time  in a single cell and have them caculated.
Example:
A                 B               C             D              E      

I have my data sheet where I have 4 columns, C-date, D-physcial, E-emotional,
F-physical....on a different sheet, I need a formula to find the peak value
and corresponding date...
I have used the large formula to find the 3 highest values and then tried to

I have a table of say 3 columns. The first column lists the part numbers ,
second column lists the serial number and the third column lists whether the
part test was a success or failure (text).
I want to search in the table of a given part number and return the total

I'm trying to count a specific value only if another column has a specific
value.
If column B=blue AND column I=App then count it.
I'm sure it's simple but I can't seem to find a function to make it work...

How do i get the solution to a function to display in the correct font
styles?  I am using formulas to create long strings of text based on if/then
statements.  I would like the output to use different kinds of fonts such as
italics, bold, or greek symbols mixed with standard ...

I want to create a short cut key(s) to be able to show or hide sheets I have
in a work book, it is on the format menu on tile bar but want to make it
quicker.

Using the following formula =IF(E49>=35,"APPROVED","APPROVAL REQUIRED"
I'm trying to return a Value of "APPROVAL REQUIRED" if the value of E4
falls between zero 0 and 35; instead if the value is zero, i'm getting
value of "APPROVED" . The formula works fine and returns a value o

I'm trying to get a formula for a spreadsheet that shows when a review was
done for an employee.
There is a "Main Info" page where the date of the last review is entered into
a cell.

I'm trying to freeze a column after i've froze a row,and when i go to window
the only option i have left is "unfreeze panes". Can somebody explain to me
how to do it?thanks.

I have a spreadsheet with a single column of numbers. There are 1000
numbers. I need to perform a count if formula on these numbers if they
are above .5. Now sometimes I need to group these numbers in groups of
10 or 20, or 50.