Thanks for replying to my posts. I took all the suggestions and came up

with this scheme:

1. ="type this around the entire formula"
2. "&type this around the specific cell reference&"
3. copy the cells, and paste special as values
4. now the new formula will be displayed, but excel will see it as text
make sure that the cell format is set to general, or number
5. create a macro:
-enter ALT+F11
-go to insert, module
-type this in the module:
Sub Enter_Values()
For Each xCell In Selection
xCell.Value = xCell.Value
Next xCell
End Sub
6. On the spreadsheet, select the cells you're working on
& run the macro Enter_Values (ALT+F8)
7. that did it for me


On Nov 20, 3:25 pm, "David Biddulph" wrote:
You could display what you ask for by the formula
="=sum("&Sheet1!B4&"+"&Sheet1!B5&")"
but of course it won't evaluate it. If you want to evaluate it you can use
the real formula in anothercell[or you can use the EVALUATE() function in
a named reference].

Note also that you don't need the word SUM in your formula. The formula
could have been =(Sheet1!B5+Sheet1B4) or =(14+15).
--
David Biddulph

wrote in ooglegroups.com...



i need to find a shortcut, maybe a marco toreplacethe formula the
refers tocellreferenceson another worksheet to dispay actual
numbers.

For example, I have =sum(Sheet1!B5+Sheet1B4) in sheet2, and i need to
have =sum(14+15), where B5=14 and B4=15 in sheet2.

please help, i have a really, really long list to work with and
wouldn't want to do this by hand....- Hide quoted text -- Show quoted text -