I found out I had this problem because I was trying to do a Find and Replace on my worksheet. Numbers that I could clearly see on the spreadsheet weren't showing up in searches.

Scenario:
The Currency Format in the cells is for a decimal and two decimal places without the dollar sign.

Example 1:
What shows up in the cell is this: 3.00
What shows up in the Formula Bar is this: 3

Example 2:
What shows up in the cell is this: 3.14
What shows up in the Formula Bar is this: 3.14

If I do a Find and Replace for 3.00, Excel can't find the data (that is because what shows in the Formula Bar is 3).
But, if I do a Find and Replace for 3.14, Excel finds the value just fine.

I did some sleuthing and JUST found that in the plain Find box, if I click to show Options, I have the option to change the Look In parameter to either Formulas, Values, or Comments. If I choose Values and do a find for 3.00, then 3.00 shows up. If I choose Formula and do a find for 3.00, Excel can't find the data.

BUT ... in the Find and Replace box under Options, the Look In option has only Formula; there is no option to choose Values or Comments. Those options ARE in the Find box, but NOT in the Find and Replace box.

It appears that in order to be able to complete a proper Find and Replace for numbers with trailing zeros, I either need for the Formula Bar to show the number 3.00 as it appears in the cell, or I need to have the Values parameter added to the Look In option.

Thank you so much for your help!