Ssn numbers

[rpcapogna71]

Hi all so i have a problem with social security numbers that start with 0 (zero).
My cell is formated special and social s number ex. 015-60-1158.
When i use the find button it will not find ssn starting with 0,
to find the ssn i'm looking for i have to key in without the zero.
Is there a way around this problem?
Thanks in advance
robert

 

[MARK858]

Duplicate of https://www.mrexcel.com/forum/excel-questions/1098018-find-button.html#post5278787

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1098018-find-button.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).