cell display is blank - microsoft.public.mac.office.excel

Version: 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.

On 5/19/10 1:08 PM, rreisley@officeformac.com wrote: > Version: 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

Exactly *how* are you going about this? Complete descriptive details are needed... ["I am creating a table that summarizes results that reference cells in other worksheets."] It sounds as though you've created formulas on the destination sheet which refer to empty cells on the source sheet. That would explain all 3 of the results: The first 2 due to formatting of cells displaying zero values, the #REF error because Excel can't identify what the formula in the cell is referring to. -- Regards |:>) Bob Jones [MVP] Office:Mac <rreisley@officeformac.com> wrote in message news:59bb8b20.-1@webcrossing.JaKIaxP2ac0... > Version: 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.

> On 5/19/10 1:08 PM, rreisley@officeformac.com wrote: > > Version: 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 > What 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.

On 5/19/10 5:30 PM, rreisley@officeformac.com wrote: > > On 5/19/10 1:08 PM, rreisley@officeformac.com wrote: > > > Version: 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 > > > > What 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. 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

> On 5/19/10 5:30 PM, rreisley@officeformac.com wrote: > > > On 5/19/10 1:08 PM, rreisley@officeformac.com wrote: > > > > Version: 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 > > > > > > > What 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. > 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 > 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?

On 5/19/10 9:49 PM, rreisley@officeformac.com wrote: > > On 5/19/10 5:30 PM, rreisley@officeformac.com wrote: > > > > On 5/19/10 1:08 PM, rreisley@officeformac.com wrote: > > > > > Version: 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 > > > > > > > > > > What 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. > > 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 > > > 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? 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

> On 5/19/10 9:49 PM, rreisley@officeformac.com wrote: > > > On 5/19/10 5:30 PM, rreisley@officeformac.com wrote: > > > > > On 5/19/10 1:08 PM, rreisley@officeformac.com wrote: > > > > > > Version: 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 > > > > > > > > > > > > > What 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. > > > 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 > > > > > 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? > 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 > 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

On 5/20/10 1:49 PM, rreisley@officeformac.com wrote: > > On 5/19/10 9:49 PM, rreisley@officeformac.com wrote: > > > > On 5/19/10 5:30 PM, rreisley@officeformac.com wrote: > > > > > > On 5/19/10 1:08 PM, rreisley@officeformac.com wrote: > > > > > > > Version: 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 > > > > > > > > > > > > > > > > What 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. > > > > 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 > > > > > > > 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? > > 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 > > > 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 Once again, I am begionning to feel like i'm beating myself on the head; What is the EXACT formula in E7? Copy the text from the formula bar and paste it into your post. Next, what is the EXACT format text. Go to format cell, and copy the format text. What does cell E7 display? I mean what is the number resulting from the formula? -- Bobgreenblattatmsndotcom

Similiar Articles:

cell display is blank - microsoft.public.mac.office.excel ...
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I am creating a table that summarizes results that reference cells in other worksheet...

How do I display an empty cell and calculate on it - microsoft ...
I am using a reference on one sheet to fill the values in another. If a cell has not value it I want it to be blank. But I also what it to be used...

Formatting 0 values to show blank cells - microsoft.public.excel ...
I am using the =IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...)) to return a zero value. For printing purposes I need the 0 to not show in the cell (blank cel...

Display empty cells as gaps, zero, or connect in chart - microsoft ...
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I recently switched from a PC to a mac. I want the chart to not leave gaps where there are blank cells ...

vlookup is reporting 0 when I want it to show a blank cell ...
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi, My vlookup formula is giving 0s when it encounters cells I've left blank my ...

Cell formulas display "0" (zero's) - microsoft ...
Here is my original Vlookup ... the formula show a blank ... Excel: blank cell to display zero value ... them up so that when their value IS EQUAL to 0 ... cell display ...

Query to show empty cells - microsoft.public.access
I am doing a database for addresses and would like to run a query showing the addresses that are empty. What should I put in the criteria to show an empty cell?

paste linked cells show "0" - microsoft.public.excel ...
The custom format of # will hide the zeros but not show decimals if your blank source cell becomes a number like 123.45 Rather than pasting links it is better, not ...

Empty cells showing that they are default formated to "Date ...
I created a spead sheet with one column set as a date the first to the end of the month. The other columns have various in text and accounting info....

formula field: don't display anything when value is zero ...
Why don't you just type an equal sign in the ... Here is my original Vlookup ... the formula show a blank ... Excel: blank cell to display zero value, blank cells, blank ...

Excel - Display Negative Values As A Blank Cell In Excel - Could ...
Display Negative Values As A Blank Cell In Excel - Could someone please tell me how to display negative... - Free Excel Help

Excel: blank cell to display zero value, blank cells, blank cell
blank cells, blank cell, value question: Andy This will work for what you need. Enter the number 1 in an unused cell and copy that cell. Highlight the cells in ...

Display or hide zero values - Excel - Office.com
Change empty cell display Select the For empty cells, show check box. In the box, type the value that you want to display in empty cells. To display blank cells ...

Excel - Need To Display Blank When A Cell Has 0 Date Value - From ...
Need To Display Blank When A Cell Has 0 Date Value - From cells A1 to A10 I have pasted a date values from... - Free Excel Help

How to Fix a Cell Phone Screen If it Went Blank | eHow.com
A cellular phone's display screen can suddenly stop working. Fortunately, this does not usually mean that it is broken. You can often bring it back to life by ...

7/18/2012 4:03:51 PM