Show formula as text

[Frank Kabel]

Hi
format this cell as 'Text' and re-enter the formula

-----Original Message-----
Excel 2000: If cell C1 is A1+B1, and shows value 6, how

do I change the formating of THAT cell so that it
shows "=A1+B1" using the menus?

It works with Tools/Options/View but for the FULL sheet.
The shortcut " Ctrl+Shift+' " does not work on all

KBoards (e.g. French) since the accent is not available
separately, and exploring the full keyboard did not yield
any answer. Even when toggling to the US International
KBoard.