It is highly unlikely the "application may be having some softwareVersion: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I am
creating a table that summarizes results that reference cells in other
worksheets. Some cells display a hyphen or zero rather than the actual
number. I have checked the cell formatting and not identified anything
unusual. I sense the application may be having some software problems. I
get #REF in some cells mysteriously, and occasional problems with server
connections to Help.
> It is highly unlikely the "application may be having some software
> problem". Post here the exact formula, the exact conternts of the
> referenced cell, and the formula's result. Then maybe we can help.
>
> --
>
> Bobgreenblattatmsndotcom
>
You are not specifying what you are doing to us dense people trying toWhat I am doing is very simple. In my table, I type "=" to start a
formula. I point to a cell on another sheet that has a number in it that
has been calculated from a formula. I hit return to complete the
equation and copy that number into the table. The result in some cell is
fine, in others it is blank or zero. While I am not an excel wizard, I
have been using the program for something like 2 decades. I have never
experienced this problem.
I don't know how to explain this any more clearly. All I am trying to do is to get a number that appears in cell C2 on worksheet 1 to appear in cell E7 on worksheet 2. I place the curser on cell E7, type =, point the curser to cell C2 on worksheet 1 and press return. I am not using a cut, copy or paste function. The number that appears in cell C2 should appear in cell E7, but it doesn't. Nobody has suggested that you are dense, where is that coming from?> You are not specifying what you are doing to us dense people trying to
> help you. We can't read your mind. I get the stuff about typing an equal
> sign, switching to another sheet and hitting return. then you say you
> copy the number to a table. Why? How? Edit copy - paste? Why don't you
> just type an equal sign in the table etc. like you did for the original
> value? Why are you copying it? What happens? What do you expect to
> happen that is not happening?
>
> --
>
> Bobgreenblattatmsndotcom
>
OK, I'm still with you. But, as before I can not see your screen and ofI don't know how to explain this any more clearly. All I am trying to do
is to get a number that appears in cell C2 on worksheet 1 to appear in
cell E7 on worksheet 2. I place the curser on cell E7, type =, point the
curser to cell C2 on worksheet 1 and press return. I am not using a cut,
copy or paste function. The number that appears in cell C2 should appear
in cell E7, but it doesn't. Nobody has suggested that you are dense,
where is that coming from?
The contents of cell E7 is a formula. The result of the formula is a number (this is an income statement). Every number and input is self contained in this worksheet, no numbers are linked to other worksheets. Calculation is set to automatically iterate 100 times. The exact format of all cells in the worksheet are the same, number with two decimals. Interestingly, the formula builder in the toolbox shows the actual result but cell displays a zer> OK, I'm still with you. But, as before I can not see your screen and of
> course have no idea of the worksheet's contents. Yes indeed, the
> contents of cell C2 of worksheet 1 should appear in E7 of worksheet 2
> after you press enter. BUT, what is in C2? A formula? A link to yet
> another worksheet? A number? Text? EXACTLY what is the content of C2, as
> seen in the formula bar? And, What is the content of E7 after you press
> enter? Is Calculation set to automatic? What is the format (exact format
> text) of cell E7?
>
> No, I'm the one who suggested that I'm dense. I'm not accusing you or
> anyone else. You need to realize that both Cybertaz and I are members of
> that exclusive and elite club, whose members have demonstrated
> extrordinary mental ineptitude: Densa.
>
> --
>
> Bobgreenblattatmsndotcom
>
Once again, I am begionning to feel like i'm beating myself on the head;The contents of cell E7 is a formula. The result of the formula is a
number (this is an income statement). Every number and input is self
contained in this worksheet, no numbers are linked to other worksheets.
Calculation is set to automatically iterate 100 times. The exact format
of all cells in the worksheet are the same, number with two decimals.
Interestingly, the formula builder in the toolbox shows the actual
result but cell displays a zer
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.