View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
shapiro shapiro is offline
external usenet poster
 
Posts: 34
Default Show value of cell in formula bar instead of formula

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