Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / August 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Leading Zero in Hexadecimal?21 Aug 2007 03:32 GMT5
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?
Add percentage to a whole column of numbers21 Aug 2007 03:18 GMT1
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-
degrees minutes seconds21 Aug 2007 03:12 GMT2
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.
How do I do simultaneous AND and OR filtering ?21 Aug 2007 02:32 GMT3
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 ...
Ranking without duplicates21 Aug 2007 01:47 GMT9
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
Subtracting Date/Time21 Aug 2007 01:42 GMT4
I know this has been asked before, but I need a little bit more help.
Ok I have this situation:
         A                             B                          C        
               D  
Count filled data rows until empty21 Aug 2007 00:57 GMT6
In VBA, how can I count the filled cells in a column until
the first empty cell?  Thanks for any help, folks.
=dman=
Saving Excel Document to PDF21 Aug 2007 00:45 GMT4
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.
Sorting VLookup vs Sorting SumProduct21 Aug 2007 00:19 GMT1
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?
chose days by month21 Aug 2007 00:16 GMT1
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 ...
Pivot Table -- Text?20 Aug 2007 23:40 GMT1
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
In Excel using URLs,  how to display pictures stored on a server?20 Aug 2007 22:50 GMT1
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
Printing Problems20 Aug 2007 22:44 GMT2
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 ...
IRR Problem20 Aug 2007 22:43 GMT1
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   
HOW DO I LOOK FOR A NUMBER IN A COLUMN IN A SPREADSHEET?20 Aug 2007 22:38 GMT3
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.