Result from formula bar

[GoKu]

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	L
5	Cycle 2	A0057267	Ernesto	J	Surface Lamp Repairer	A3	2008-07-01 00:00:00.000	3231.02	NULL	NULL	=I5*0.1
Sheet1

Hi Everyone. When I type in a formula in L5, the formula is shown and not the result of the formula. Im using Office 2K7, even if I toggle the Show/Hide formula button, the formula stays displayed. Any suggestions?

 

[Stormseed]

Hi Goku

First option:
Right now I am @ office so no access to Excel 2007. However, in Excel 2003 and below, Click on Tools --> Options --> View tab --> in Window options --> uncheck the option called "Formulas" --> Click on OK.

Second option:
Try pressing CTRL+` (A combination of Ctrl and Tilde, Tilde is the first character on the keyboard right below Escape).

Edit: You can try the second option in Excel 2007.

See if it works !

 

[GoKu]

Hi Storm.
Pressing Crtl+~ has the same result as me toggling the show/hide formula option, it still only displays the typed formula.

 

[Stormseed]

Ok.

Let me check it out on my home PC after I get home.

 

[Stormseed]

hi Goku

I bet, you never searched for this problem on the Board, did you ?

Here, check this out:

http://www.mrexcel.com/archive2/17600/19935.htm

 

[GoKu]

Thanx buddy, "F2" worked perfectly.