Is the sheet protected? You can set cells to be locked and hidden, and
when protection is applied the cells behave as you have described.

Hope this helps.

Pete

On Jan 30, 11:42*pm, Brettjg
wrote:
Hi there, my formula bar is displayed, and usually the contents (value or
formula) is displayed there. However, in another workbook that I did not
create, the contents of the cell does not display in the formula bar. I can't
seem to find anything in options to change this.

Thankyou for any help that comes my way. Brett