![]() |
|
#1
|
||||
|
||||
![]()
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] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
UnholySmoke | Excel | 2 | 09-14-2011 08:15 AM |
![]() |
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 |
![]() |
Lsbutler2000 | Mail Merge | 1 | 06-22-2007 06:33 AM |