Find button

[rpcapogna71]

Hi all I have a sheet with soc. S numbers and start with 0. How do format so excel will find the ssn starting with 0?

 

[DanteAmor]

I think something was lost in your requirement, you could give examples of what you have and what you expect of result.

 

[rpcapogna71]

I have a list of social security numbers. My problem is excel wont find the ssn starting with 0.
That when I use the find button.
Thanks for responding.

 

[DanteAmor]

It works for me, what parameters do you have?

 

[rpcapogna71]

It's not working for me the cell with the SSN number is in special and social security number format? what format is yours?

 

[DanteAmor]

If the format is applied, it does not allow you to create a ss with zero, the format in automatic puts it the zero. But you must look for the data without the zero.