formulas in columns formatted as text

  • Thread starter Thread starter Dave F
  • Start date Start date
D

Dave F

Column U is formatted as text.

If I enter a formula, say =COUNTA(U1:U10) in U15 the formula doesn't
calculate but rather just appears as =COUNTA(U1:U10) .

Is there a way to make formulas work in columns formatted as text? Or
do I just have to deal with having the above formula in a different
column?
 
Say in U1 we have:
=S1+T1
it will show as text.

1. select column U
2. apply Text to Columns to column U putting the result on top of itself
3. the formulas will now become active (sadly the results of the formula are
still Text)
 
Back
Top