display '2+2' as '4' in a cell?

[damien]

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

 

[Ron Rosenfeld]

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

 

[damien]

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

 

[GS]

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'd like to know how "corporate" was able to "give" your coworker a
cell when cells are not transferable off the sheet!

If you're saying that just typing numbers into a cell (ie: 22) causes
the cell to automatically display the sum of those numbers then it must
be using VBA in a worksheet event, OR an addin that monitors events. In
either case the result can be restricted to a single cell or a range of
cells.

Otherwise, formula-style entry (as Ron suggested) is the common way to
do this sort of thing!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[lhkittle]

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

This will add the numbers in a cell (A1) in this, but does not do it in the same cell as the numbers. Commit with ctrl + shift + enter. You will get {...} around the formula.

=SUM(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))

Regards,
Howard

 

[Ron Rosenfeld]

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.