Converting Text to Number by formula (Opposite to Text("000",A1) )

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Hi All

I have several lists of data which have Centres Numbers, some
formatted as Text (i.e 012 format) and others formatted like Numbers
(i.e 12 format).

Now I know how to convert a number to text by formula ( Text
("000",A1) ) however I do not know how to convert the other way around
to make Text a single number.

The only way I know to do this is text to columns or by clicking the
smart tag to convert them, however I want to try and achieve this by
formula as I have several data lists to paste in, I would like it to
do it automatically.

Hope someone can help!

Kind regards
Adam
 
Several ways, like this:

=A1+0

=A1*1

=--A1

=VALUE(A1)

where A1 is a text value that looks like a number.

Hope this helps.

Pete
 
Back
Top