Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel 97 formula problem
Name: shauncwalsh Date: February 17, 2004 at 06:27:00 Pacific OS: Win 98SE CPU/Ram: Duron 1200/512MB
Comment:
I want to insert a formule into a cell in a worksheet which simple displays the value contained in a cell in another sheet in the same workbook. The formula is: =DataEntry!E16 So the cell should display the value of cell E16 in the DataEntry worksheet in the same workbook. Instead it will only display the formula, not the result! I have checked to make sure that the "display formulae" option is not ticked in Tools/Option/View. Also, the same formula in a different cell works correctly. Help!
Name: Report_2 Date: February 17, 2004 at 07:05:48 Pacific
Reply:
You should be able to click on your destination cell and place an equal (=) sign in it; swap to the DataEntry sheet and click in E16, hit the Enter key and it should return it's value to your destination cell.
HTH Bryan
0
Response Number 2
Name: shauncwalsh Date: February 17, 2004 at 07:19:43 Pacific
Reply:
Tried that Bryan, no luck. However I did check how the cell was formatted and changed it to "General", that seems to have done the trick!
Summary: I have a bit of an excel problem I want to do the sum of cells which contain if formulas. But if i do a sum of them it returns zero So i need some method to do a sum of the values of these cells. Help...
Summary: HEY! I have excel 97 - I am having issues with sharing files/workbooks. Other's in the office have Excel 2003 and don't run into this issue - the upgrade to 2003 doesn't fix it either. After openin...
Summary: Excel row height problem using sort. I have a Excel work sheet the rows are of various size. Most are 20 high, some are 30 high. Now if I do a sort the size of the cell is not kept with the cell so I ...
0 
