| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked cell displays 0
Hi,
I copied a cell that contains the value: Apples. I Special Pasted then clicked Paste Link. The new linked cell shows the value 0 (zero), not Apples. I checked the link cell for it's formatting. It is in the "General" mode. This is actually a report with a lot of links. They all are reporting 0 suddenly. instead of what is really in the original cell. They used to work. I tried looking in the archives of the newsgroup for this, but maybe I didn't word it write. Thank you for your time, Amy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linked cell displays 0
Try changing calculation to automatic.
tools|options|calculation tab And if that cell is empty, you can display "" by something like: =if(sheet1!a1="","",sheet1!a1) AMY Z. wrote: Hi, I copied a cell that contains the value: Apples. I Special Pasted then clicked Paste Link. The new linked cell shows the value 0 (zero), not Apples. I checked the link cell for it's formatting. It is in the "General" mode. This is actually a report with a lot of links. They all are reporting 0 suddenly. instead of what is really in the original cell. They used to work. I tried looking in the archives of the newsgroup for this, but maybe I didn't word it write. Thank you for your time, Amy -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linked cell displays 0
Thanks Dave. It worked.
Somebody else was at my computer. I never use the manual calc. Also thanks for the empty cell formula tip. Amy "Dave Peterson" wrote: Try changing calculation to automatic. tools|options|calculation tab And if that cell is empty, you can display "" by something like: =if(sheet1!a1="","",sheet1!a1) AMY Z. wrote: Hi, I copied a cell that contains the value: Apples. I Special Pasted then clicked Paste Link. The new linked cell shows the value 0 (zero), not Apples. I checked the link cell for it's formatting. It is in the "General" mode. This is actually a report with a lot of links. They all are reporting 0 suddenly. instead of what is really in the original cell. They used to work. I tried looking in the archives of the newsgroup for this, but maybe I didn't word it write. Thank you for your time, Amy -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Linked cell location of hyperlink | Excel Worksheet Functions | |||
Linear Mode
