You can view the value in the formula bar. But the cell will loose the Object
Linking and Embedding (OLE) and Dynamic Data Exchange DDE funtionality. The
values will just display as an independent cell value. Any change change in
the source document will not reflect any changed value. If this is what you
require then you can copy and paste special and then click Values. The
formula bar will display only display the value.

Important: You will have to create the function(s) for each cell values again.

Challa Prabhu

"shapiro" wrote:

Is it possible to display the value of a cell in the "formula Bar" rather
than its formula without password protecting the worksheet?
for eg:
A
1 20
2 30
3 50 =SUM(A1:A2) Shown in formula bar
Would like to see 50 Shown in formula bar