(1) I need a formula in a cell that monitors my Column (H14:H5000).
The data is inserted into this column by a macro from an entry screen.
I need to be alerted by a number count or statement that I have entries exceeding 2 decimal places in this column. Entries in this column are supposed to have only 2 decimal places: 25.65, but sometimes a 3rd digit: 25.655 (not visible) is hit in error.
(In the future I would like to be alerted at the point of first entry before the macro is run, but for now I have this whole column to check)
(2) Next I need a method other than manually scaning for these errant entries. I need to identify the location(s) for correction.
Thanks
Bookmarks