How to make this Custom Filter?

E

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.
 
K

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.
 
K

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.
 
Top