Excel Mac "Find" not working properly -- doesn't find formatted values (version 16.35 mac mini)

%3CLINGO-SUB%20id%3D%22lingo-sub-1162407%22%20slang%3D%22en-US%22%3EExcel%20Mac%20%22Find%22%20not%20working%20properly%20--%20doesn't%20find%20formatted%20values%20(version%2016.35%20mac%20mini)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1162407%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20unable%20to%20%22find%22%20a%20value%20though%20it%20indeed%20exists%20in%20my%20workbook.%20%26nbsp%3BThe%20problem%20is%20that%20I%20am%20using%20a%20dollar%20format%2C%20and%20it%20only%20finds%20the%20UNFORMATTED%20version.%20%26nbsp%3BThis%20is%20shown%20below%20in%20the%20blue%20oval%20--%20it%20finds%20the%20value%20on%20the%20left%2C%20but%20not%20the%20value%20on%20the%20right.%20%26nbsp%3BYet%2C%20there%20is%20no%20%22format%22%20dialog%20box%20in%20the%20current%20find%2C%20to%20change%20the%20format%20it%20is%20looking%20for.%20%26nbsp%3BThis%20is%20obviously%20unacceptable%20--%20I%20need%20to%20find%20values%2C%20no%20matter%20how%20they%20are%20formatted.%20%26nbsp%3BAnyone%20else%20having%20this%20problem%3F%20%26nbsp%3BScreen%20shot%20attached.%20%26nbsp%3BThank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202020-02-08%20at%205.04.32%20PM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F169893iD3D423DC4CF90594%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screen%20Shot%202020-02-08%20at%205.04.32%20PM.png%22%20alt%3D%22Screen%20Shot%202020-02-08%20at%205.04.32%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

I am unable to "find" a value though it indeed exists in my workbook.  The problem is that I am using a dollar format, and it only finds the UNFORMATTED version.  This is shown below in the blue oval -- it finds the value on the left, but not the value on the right.  Yet, there is no "format" dialog box in the current find, to change the format it is looking for.  This is obviously unacceptable -- I need to find values, no matter how they are formatted.  Anyone else having this problem?  Screen shot attached.  Thank you!

 

Screen Shot 2020-02-08 at 5.04.32 PM.png

0 Replies