Not showing a as Formula

[gtd526]

Hello,
Want to know why its not showing as a formula.
And the formula is changing when copy/pasted in this window?

Wagers.xlsm
	O	P	Q	R	S
18	Bets	Team	W	L	W %
19	0	IFERROR(LOOKUP(2, 1/((COUNTIF($H$520:$H520,[NBA.xlsm]Favs!$H$4:$H$33)=0)*([NBA.xlsm]Favs!$H$4:$H$33<>"")),[NBA.xlsm]Favs!$H$4:$H$33),"")	0	0
20	2	TOR	1	1	50%
21	1	SAN	0	1	0%
22	9	MIA	4	5	44%
23	8	PHX	5	3	63%
24	6	UTA	5	1	83%
NBA

Cell Formulas
Range	Formula
O19:O24	O19	=Q19+R19
P19:P24	P19	=IFERROR(LOOKUP(2, 1/((COUNTIF($P$18:P18,$H$175:$H$825)=0)*($H$175:$H$825<>"")),$H$175:$H$825),"")
Q19:Q24	Q19	=COUNTIFS($A$175:$A$825,"W",$H$175:$H$825,$P19)
R19:R24	R19	=COUNTIFS($A$175:$A$825,"L",$H$175:$H$825,$P19)
S19:S24	S19	=IFERROR(Q19/(Q19+R19),"")

 

[arthurbr]

Cell formatted as Text instead of general? Format as general, place insertion and hit F2

 

[gtd526]

Cell formatted as Text instead of general? Format as general, place insertion and hit F2

Its formatted as General. When I removed the "=" sign(P19) it effects the formula below (P20).

Wagers.xlsm
	O	P	Q	R	S
18	Bets	Team	W	L	W %
19	0	IFERROR(LOOKUP(2, 1/((COUNTIF($P$18:P18,$H$175:$H$825)=0)*($H$175:$H$825<>"")),$H$175:$H$825),"")	0	0
20	0	IFERROR(LOOKUP(2, 1/((COUNTIF($H$520:$H520,[NBA.xlsm]Favs!$H$4:$H$33)=0)*([NBA.xlsm]Favs!$H$4:$H$33<>"")),[NBA.xlsm]Favs!$H$4:$H$33),"")	0	0
21	2	TOR	1	1	50%
22	1	SAN	0	1	0%
23	9	MIA	4	5	44%
24	8	PHX	5	3	63%
25	6	UTA	5	1	83%
NBA

Cell Formulas
Range	Formula
O19:O25	O19	=Q19+R19
Q19:Q25	Q19	=COUNTIFS($A$175:$A$825,"W",$H$175:$H$825,$P19)
R19:R25	R19	=COUNTIFS($A$175:$A$825,"L",$H$175:$H$825,$P19)
S19:S25	S19	=IFERROR(Q19/(Q19+R19),"")
P20:P25	P20	=IFERROR(LOOKUP(2, 1/((COUNTIF($P$18:P19,$H$175:$H$825)=0)*($H$175:$H$825<>"")),$H$175:$H$825),"")

 

[arthurbr]

Why should you remove the "="sign? Did you try as suggested entering an insertion point behind the formula then hitting F2?

 

[gtd526]

Why should you remove the "="sign? Did you try as suggested entering an insertion point behind the formula then hitting F2?

I removed the = sign to see if there are any differences.
What do you mean by 'insertion point'? and F2 only decreases my display brightness.