I posted this earlier but didn't get the answer I needed so will try again.
目前分類:title (4957)
- Jun 04 Wed 2008 20:44
Format Round to Nearest Thousand
- Jun 04 Wed 2008 20:44
maximum number size/significant digits
I seem to have hit a limit of 16 significant digits. For example:
1E 15 1 = 1000000000000001 (16 significant digits)
- Jun 04 Wed 2008 20:44
DSUM : what am I doing wrong?
- Jun 04 Wed 2008 20:44
IF formulas
Hi
- Jun 04 Wed 2008 20:44
difficulties
i have over 3000 cells with values that i wont have time to re-enter i need
to know how to prevent excel from multiplying the values by 100 when i change
- Jun 04 Wed 2008 20:44
Last non-blank cell in a row?
- Jun 04 Wed 2008 20:44
Dynamic flexible cell address
- Jun 04 Wed 2008 20:44
Displaying data
Good morning everyone.
- Jun 04 Wed 2008 20:44
Confirm before deleting a worksheet?
When deleting a worksheet, is there a setting in Excel 2003 where it will
prompt you whether you really want to delete the worksheet?
- Jun 04 Wed 2008 20:44
Can Excel find amp; sort one item in all the cells in a column?
Can Excel find amp; sort one item in all the cells in a column? My list
contains items that I want to assign to one or more categories in a single
- Jun 04 Wed 2008 20:44
Conditional formatting of text in a shared workbook.
My work group shares a simple spreadsheet to track the work (journals) we get
in daily. There are certain journals (100 total) that have priority and need
- Jun 04 Wed 2008 20:44
How print header row at top of each page?
How do you get Excel 97 to print the header row at the top of each printed
page when the data is 300 or 400 rows long, for instance?
- Jun 04 Wed 2008 20:44
Clear all?
Is there a way to clear all inputs to an existing workbook - everything but
the formulas?
- Jun 04 Wed 2008 20:44
Help with TREND function
- Jun 04 Wed 2008 20:44
Deleting dates and vlookup
- Jun 04 Wed 2008 20:44
How do I merge two cells in a column
I am trying to merge cell A1 and cell A2 into one cell. I select both cells
by selecting one and then hitting shift while I select the other but the
- Jun 04 Wed 2008 20:44
keep new menu item with workbook
Hi, I have some code that works for displaying different titles and hiding or
displaying info on a worksheet. The problem is it works with the view menu
- Jun 04 Wed 2008 20:44
Can I use more complex logical expression for sumif as creteria?
I want to use a more complex logical expression as creteria in SUMIF. For
example, sum number in the cell on column 6 when cell on column 1 is quot;MAquot; AND
- Jun 04 Wed 2008 20:44
numbering add-in
I keep getting the message regarding numbering add in, where do I find it and
how do I install it, I cant find any information anywhere
- Jun 04 Wed 2008 20:44
Adding a Tab in a Macro
I'm running a simple macro to find and go to a cell containing specific
data using the cell.find method.