On Thu, 21 Mar 2013 19:27:53 -0700 (PDT), damien wrote:

On Thursday, March 21, 2013 5:55:45 PM UTC-7, Ron Rosenfeld wrote:
On Thu, 21 Mar 2013 17:15:03 -0700 (PDT), damien wrote:



I have a coworker who is trying to add two numbers within 1 cell and have it calculate the corresponding value.



I've tried formatting, and conditional formatting. Any pointers?



-d



Precede with equal sign? =2+2

That does indeed work, but my coworker has a cell that "corporate" gave him that does it automatically without hitting the plus sign. We can't seem to replicate the autofill nature of it

I have no idea how to enter the string 2+2 "without hitting the plus sign"

I would suggest posting the "cell" at some publically shareable website (e.g. Skydrive) and posting a link here. Some of what you write might be doable with VBA, or other methods.