How to make this Custom Filter?

[Excel Dummy]

I have a spreadsheet generated by .ASP, saved as .xls, has over 1,000
rows and 10 columns are using in-line format to keep leading zeros from
SQL. Values for these colums are in this form, ="001", ="002", ="023".

Try to do filtering using Custom, choosing "is greater than", none of
the following produce correct result:
="001"
value(="001")
"="001""

Thanks.

 

[Kletcho]

I would do a text to columns function on that column to convert it from
a formula of a text value to an actual text value.

 

[Kletcho]

I would do a text to columns function on that column to convert it from
a formula of a text value to an actual text value.

 

[Excel Dummy]

Can you please show how?

 

[Francisco GMAIL]

you need ?

 

[Excel Dummy]

Yes, thanks.

 

[Kletcho]

Select the column you wish to change, then go to Data -- Text to
Columns. Then click finish on the pop up screen. Normally you use
this function to take information and parse it to multiple columns (for
example if you had Smith, Joe you could parse the first and last names
into 2 columns). It is also helpful in just converting data into text
if you don't designate any delimiters.