目前分類:title (4957)

瀏覽方式: 標題列表 簡短摘要

I posted this earlier but didn't get the answer I needed so will try again.

software 發表在 痞客邦 留言(0) 人氣()

I seem to have hit a limit of 16 significant digits. For example:
1E 15 1 = 1000000000000001 (16 significant digits)

software 發表在 痞客邦 留言(0) 人氣()


ok...let's see if I can explain the problem...

software 發表在 痞客邦 留言(0) 人氣()

Hi

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()


Hello to all! My first post! Help me if you can.

software 發表在 痞客邦 留言(0) 人氣()


I have 1000 names in sheet1. (Cells A1 to A1000)

software 發表在 痞客邦 留言(0) 人氣()

Good morning everyone.

software 發表在 痞客邦 留言(0) 人氣()

When deleting a worksheet, is there a setting in Excel 2003 where it will
prompt you whether you really want to delete the worksheet?

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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?

software 發表在 痞客邦 留言(0) 人氣()

Is there a way to clear all inputs to an existing workbook - everything but
the formulas?

software 發表在 痞客邦 留言(0) 人氣()


Hi all,

software 發表在 痞客邦 留言(0) 人氣()


I have a vlookup working between two workbooks, however one of the

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

I'm running a simple macro to find and go to a cell containing specific
data using the cell.find method.

software 發表在 痞客邦 留言(0) 人氣()