I have the following in cells
D3: -2.5 -111
目前分類:title (5957)
- Jun 22 Fri 2007 20:38
Split text without using data-text to columns
- Jun 22 Fri 2007 20:38
i have two days and i want the difference in days, months, year
21/3/2006
20/2/2005
- Jun 22 Fri 2007 20:37
Calculating time interval (some across midnight)
I need to calculate two columns of time. Most entries fall within the
same day's 24 hour limit, so a simple forumla quot;=b1-a1quot; will do. But a
- Jun 22 Fri 2007 20:37
IF ColumnA = ltr Add Column B
I'm trying to create a daily task list.
In column A I have task acronyms, in column B I have the time taken to do
- Jun 22 Fri 2007 20:37
Excel will not let me type any characters....I can type in Word.
Excel will not let me type any characters....I can type in Word.
I was entering numbers and suddenly, I was no longer able to type in any
- Jun 22 Fri 2007 20:37
Removing patterns but keeping fill colour
- Jun 22 Fri 2007 20:37
Excel on a dual-core Pentium..no benefit?
I just purchased a computer for some serious number crunching. I'm running
Excel 2003 under Windows XP Professional. The new machine has 4GB of memory
- Jun 22 Fri 2007 20:37
Max of a defined function
OK, maybe there's a better way to do this, but I have the Colorindex function
(from Ozgrid, I think) and I want to get the maximum value over a number of
- Jun 22 Fri 2007 20:37
Disable Update Automatic Links
I have a user that receives orders on a spreadsheet via e-mail from a
customer on a daily basis. This user doesn't use spreadsheets with external
- Jun 22 Fri 2007 20:37
ADD PREFIX TO COLUMNS
I have #'s in columns and need to add a prefix to each column, I have about
10k rows
- Jun 22 Fri 2007 20:37
geographic MAP to Excel 2003
- Jun 22 Fri 2007 20:37
Array formula combined with Lookup
- Jun 22 Fri 2007 20:37
Eliminate Duplicate Rows
Hi anyone helpme to sort out this problem.
- Jun 22 Fri 2007 20:37
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?
Please Help!!!
I am trying to have excel find the highest x number in a group of
- Jun 22 Fri 2007 20:37
Excel 2003 list of field codes for footers?
Hi - I am trying to add a quot;saved byquot; type of field to a custom footer in
Excel 2003. What I want is a document to print with footers that say who has
- Jun 22 Fri 2007 20:37
I am looking for a calendar with weeknumbers.
- Jun 22 Fri 2007 20:37
I want a title to print on every page of a worksheet; not a header
I want the column headings for each column to print at the top of each page
instead of me having to copy and paste it at the beginning of each page.
- Jun 22 Fri 2007 20:37
Format cells in pivot table
Is it possible to set a default cell format in a pivot table that works even
when you update the pivottable and get more rows?
- Jun 22 Fri 2007 20:37
follow hyperlink?
is it possible to to put a url in a cell where the cell displays the
destination (picture) instead the hyperlink address?
- Jun 22 Fri 2007 20:37
How to maintain employment history
I want to keep track of my employment history by employing a Microsoft
product that I currently have available. I am open to suggestions regarding