Simplest way i have found is just to add zero like this, if your text was in cell AI in cell B1 you would have 0+A1 the Zero can also be added to any other formula you may have.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________