when i'm doing caluclations in excel, i want to "show my work". I dont
mean just showing the formula (eg. =A10 + B20, you can do this if you
copy/paste the function in the cell). But instead, say if the value in
A10 is 1 and B20 is 2, i want it to show "=1+2" in the cell.

I understand if I type in the cell: '=A10& "+" B20, it'll show what i
want. but it'll be veyr troublesome. I need a more automated easier
way, almost as easy as say copy and pasting as a special option.

I need this so that show my work on the worksheet.

Is there possibly a macro/add-in for this>?

thanks


--
fuc847
------------------------------------------------------------------------
fuc847's Profile: http://www.excelforum.com/member.php...o&userid=27464
View this thread: http://www.excelforum.com/showthread...hreadid=469789

If you are looking for a worksheet solution and only the values either
constants or formulas in A10 and B20 change then you could use
="=" & VALUE(A10) & "+" & VALUE(B20)

Another example with columns D & E

Displayed -- personal.xls!GetFormula(D3)
1 D3: 1
20 D4: =20*D3
21 D5: =D3+D4
=1+20 D6: =VALUE(D3) & "+" & VALUE(D4)

The user defined function in E4 showing the formula in D4 can be seen in
http://www.mvps.org/dmcritchie/excel...tm#getformulad

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"fuc847" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> when i'm doing caluclations in excel, i want to "show my work". I dont
> mean just showing the formula (eg. =A10 + B20, you can do this if you
> copy/paste the function in the cell). But instead, say if the value in
> A10 is 1 and B20 is 2, i want it to show "=1+2" in the cell.
>
> I understand if I type in the cell: '=A10& "+" B20, it'll show what i
> want. but it'll be veyr troublesome. I need a more automated easier
> way, almost as easy as say copy and pasting as a special option.
>
> I need this so that show my work on the worksheet.
>
> Is there possibly a macro/add-in for this>?
>
> thanks
>
>
> --
> fuc847
> ------------------------------------------------------------------------
> fuc847's Profile: http://www.excelforum.com/member.php...o&userid=27464
> View this thread: http://www.excelforum.com/showthread...hreadid=469789
>

fuc847 -

When a cell containing a formula is selected so that the formula shows in
the formula bar, you can select portions of the formula in the formula bar
(by click-and-drag or double-click) and then press F9 to evaluate that
selected portion of the formula.

This isn't what you want because it's not displayed in the cell, and you may
already be aware of this feature. But it might be close enough to assist
you.

- Mike
www.mikemiddleton.com

"fuc847" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> when i'm doing caluclations in excel, i want to "show my work". I dont
> mean just showing the formula (eg. =A10 + B20, you can do this if you
> copy/paste the function in the cell). But instead, say if the value in
> A10 is 1 and B20 is 2, i want it to show "=1+2" in the cell.
>
> I understand if I type in the cell: '=A10& "+" B20, it'll show what i
> want. but it'll be veyr troublesome. I need a more automated easier
> way, almost as easy as say copy and pasting as a special option.
>
> I need this so that show my work on the worksheet.
>
> Is there possibly a macro/add-in for this>?
>
> thanks
>
>
> --
> fuc847
> ------------------------------------------------------------------------
> fuc847's Profile:
> http://www.excelforum.com/member.php...o&userid=27464
> View this thread: http://www.excelforum.com/showthread...hreadid=469789
>