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

[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

 

[Pete_UK]

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

 

[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

Thank you Pete!

 

[Pete_UK]

You're welcome, Adam - thanks for feeding back.

Pete