I am running MS Excel 2007. One of the workbooks is my Daily journal with about 20000 rows. Column A is formatted for date. Column B is for description of daily activity and column C is formatted for currency. Often I use the FIND & Select tool to find data related to past activities. Let's say I am searching for a currency amount of 42,500.55 in column C. I enter 42,500.55 or 42500.55 in the FIND tool and neither returns a result. But if I enter 42500 then it finds the data. I like to know why Excel cannot find the result by the actual recorded number in the workbook.
I appreciate your help.
Shardon
Bookmarks