filtering out text from numbers

Thanks,
tried that but some format or somethign is stopping that from differentiating text from the strings of 0001111000 that I want. Have found a long hand way to do it now

Cheers

Simon

It's easy to see why it did not work as desired......0001111000 is not a
number....it is actually a TEXT value just as much as a letter-character
string. If all of the values you want to delete start with a leading zero,
then this formula should help.........

=IF(Left(A1=0,"",A1)

Vaya con Dios,
Chuck, CABGx3



"simonsmith" <simonsmith.2cai00_1155155799.0494@excelforum-nospam.com> wrote
in message news:simonsmith.2cai00_1155155799.0494@excelforum-nospam.com...
>
> Thanks,
> tried that but some format or somethign is stopping that from
> differentiating text from the strings of 0001111000 that I want. Have
> found a long hand way to do it now
>
> Cheers
>
> Simon
>
>
> --
> simonsmith
> ------------------------------------------------------------------------
> simonsmith's Profile:
http://www.excelforum.com/member.php...o&userid=34235
> View this thread: http://www.excelforum.com/showthread...hreadid=570070
>

It's easy to see why it did not work as desired......0001111000 is not a
number....it is actually a TEXT value just as much as a letter-character
string. If all of the values you want to delete start with a leading zero,
then this formula should help.........

=IF(Left(A1=0,"",A1)

Vaya con Dios,
Chuck, CABGx3



"simonsmith" <simonsmith.2cai00_1155155799.0494@excelforum-nospam.com> wrote
in message news:simonsmith.2cai00_1155155799.0494@excelforum-nospam.com...
>
> Thanks,
> tried that but some format or somethign is stopping that from
> differentiating text from the strings of 0001111000 that I want. Have
> found a long hand way to do it now
>
> Cheers
>
> Simon
>
>
> --
> simonsmith
> ------------------------------------------------------------------------
> simonsmith's Profile:
http://www.excelforum.com/member.php...o&userid=34235
> View this thread: http://www.excelforum.com/showthread...hreadid=570070
>