Differentiate real text and number stored as text

[silverxx12]

Hi

Can anyone help here.

I have a spreadsheet which has number stored as text and other cells which are real text strings for eg

A1

12345 ( number stored as text)
real text

What i want to do is filter and show only the cells where number is stored as text. i tried "istext" function, but all are text and all appear as true.

Appreciate any help here

thanks in advance

silver

 

[Jonmo1]

Try

=ISNUMBER(A1+0)
This will be TRUE for numbers stored as text (as well as actual real numbers)

Or ISERROR(A1+0)
This will be true for actual text strings

Hope that helps.

 

[kpark91]

Try filtering with

=IFERROR(VALUE(A1), "ERROR") method..

this will print "ERROR" when it is text
and will print the value of A1 as number when it is number