 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Adding to a formula
I am trying to add a cell from one worksheet to a formula in another worksheet but it just shows the forumula in the total box instead of the figure what am I doing wrong?  SignatureJooles Firstly, post the formula you are getting and secondly make sure you have formatted the cell as number. Regards Michael M > I am trying to add a cell from one worksheet to a formula in another > worksheet but it just shows the forumula in the total box instead of the > figure what am I doing wrong? Thankis for the help partly helped - finishing it off by double clicking on cell and pressing return changed it to the number. Regards. SignatureJooles > Firstly, post the formula you are getting > and secondly make sure you have formatted the cell as number. [quoted text clipped - 5 lines] > > worksheet but it just shows the forumula in the total box instead of the > > figure what am I doing wrong? your cell is probably formatted as text. Change it to Number or General oranything other than text. Once it has been reformatted you will still need to update the cell. Double click on the cell to get inot formula edit mode and then hit <Enter> to exit. SignatureHTH... Jim Thomlinson > I am trying to add a cell from one worksheet to a formula in another > worksheet but it just shows the forumula in the total box instead of the > figure what am I doing wrong? Thanks Jim it worked - I have spent hours trying to figure it out. Regards. SignatureJooles > your cell is probably formatted as text. Change it to Number or General > oranything other than text. Once it has been reformatted you will still need [quoted text clipped - 4 lines] > > worksheet but it just shows the forumula in the total box instead of the > > figure what am I doing wrong? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.