Not sure where the question was, or what the question is, but you can try
putting these in front of the range that contains text (or reference to a
cell that contains a text number): --

Which will for example turn a text string of " 005" to the number 5.






"Text Cell Computations" <Text Cell
wrote in message ...
=IF(c2="ABC",TRUE,FALSE) doesn't do anything
=(a2 & b2) doesn't concatenate 2 text cells
=CONCATENATE(A2,B2) DOESN'T CONCATENATE 2 CELLS

All arithmetic computations seem to work OK