Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-07-2011, 02:59 PM
macropod's Avatar
macropod macropod is offline Calculation within Cells Windows 7 64bit Calculation within Cells Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,359
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Alternatively, so that you can continue to see the component parts of the cell value in the formula bar, simply insert a '=' sign before the first # (you might even make this a habit for the initial data entry), then insert a '+' sign followed by the second value. You can keep inserting '+' (or '-') signs followed by values as required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculation within Cells Excel Calculation Problem UnholySmoke Excel 2 09-14-2011 08:15 AM
Calculation within Cells Help with 'hours worked' calculation... Snvlsfoal Excel 1 08-11-2011 05:54 AM
NETWORKDAYS calculation for entire column Salient Excel 0 07-11-2011 03:58 PM
Count range cells eliminating merge cells danbenedek Excel 0 06-15-2010 12:40 AM
Calculation within Cells Mail Merge Calculation Error Lsbutler2000 Mail Merge 1 06-22-2007 06:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:16 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft