I'm using the DEC2HEX function to convert decimal numbers in cells to hex numbers.
For Hex 00 to 09, how do I format the cells so that there is a leading zero?

I have found it most difficult to find a simple solution to this
question/problem.
I need to add a percentage to a column of numbers.
For example-

How do I formate a cell or column of cells to handle full angular
measurements.  eg 359degrees 59' 59.99"  Similar to time except the 'hour'
would go up to 360 not 24.

I would like to do a filtering operation that is a combination of an AND
command and an OR command.  In other words, I have a worksheet consisting of
data in say, columns A, B, and C that I am requiring to be greater than zero.
In another set of columns in the worksheet, say ...

Sorry to bring this subject up again, but i'm really confused!!!
My Example:
On a one sheet spread I want to auto sort and rank a list.
In A1 to A4 I have the players: John, Bob, Dave, Ian

I know this has been asked before, but I need a little bit more help.
Ok I have this situation:
         A                             B                          C        
               D  

In VBA, how can I count the filled cells in a column until
the first empty cell?  Thanks for any help, folks.
=dman=

I would like to save all my Sheets to one PDF. All can do right now is save
each Excel Sheet individually.
Could someone let me know how I can Save all of my information from the
Excel Document to 1 PDF document.

How come I can sort a table with multiple columns of vlookup and retain the
integrity of the data but I can't sort a table with multiple columns of
sumproduct while retaining the integrity of the data.
Any ideas?

I would like to write a function that is different for each month.  My dates
are written in dd/mm/yy format.  i am looking for a way to reference the
specific cells in a month without referencing day by day.  For example i
would write an IF statement like =IF(A1=(SOME DAY IN ...

I don't think this is possible, but thought I'd check to be sure.
Can a pivot table display text values or must a pivot table do calculations
and only display numbers??
I am basically trying to create a report from data I pulled from MS

For Excel 2003 SP2:
I want to prepare an Excel report where the output rows have a photo and
it's description. In each row, 1 cell is for the description, the next is the
photo and the 3rd is for another person's comments about the photos on each

i think that I must have hit the wrong button at the right time or something.
Every time I try to print a particular spreadsheet a window pops up asking
me to "Save As" the document as a Microsoft Document Imaging Format.  If I
save it as such and hit print again, the same ...

I'm having difficulty calculating an IRR for a set of cash flows. The cash
flows are as follows:
-$450,000.00   
-$70,107.78   

i have rma numbers in column C, i only want to look through column, i want to
type in the rma number when i receive it and the spreadsheet says here it is
line whatever....
i just can not seem to get it to look for the number i type in and need to