1Dec/080
How to Convert Excel Text into Numbers
If you need to convert a text field that has numbers in it to an actual number, the easiest way to do it is to multiply the field by 1.
For example, if all the values in column A have numbers that are stored as text, you cannot Sum them. This can be frustrating when so many reports export values in a text format.
Simply go to an open column and add a formula that multiples the value in column A by 1. The result should be the same value as what is in A, only in a number format, and allow you to perform other math functions, like Sum.
![[del.icio.us]](http://images.del.icio.us/static/img/delicious.small.gif){kind=small}