Formula doesn't calculate at a specific range

[yxz152830]

Gurus,
I have an excel sheet that a specific range of cells dont calculate formulas. At first I thought it's the calculate option but automatic calculation is on. Also I can do calculation outside of the range. It's only within the range that I cannot do the calculation, not even inserting new columns help. Any suggestions? Thanks a lot!

 

[yxz152830]

 

[Fluff]

It sounds as though those cells are formatted as text. Change them to General & re-enter the formula.

 

[James006]

Hi,
Would you have certain cells formatted as Text ...?

 

[yxz152830]

It sounds as though those cells are formatted as text. Change them to General & re-enter the formula.

omg yes I'm dumb

 

[Fluff]

Glad we could help & thanks for the feedback.