Hello Everyone,
I have recently discovered an issue with the find and replace function. I do not know if it is an issue with my system, but it has me completely stumped. I am trying to convert a column of dollar amounts to their plain number equivalent. For example, $1,500.00 to 1500. So to do this, the easiest solution I can think to do is to find a replace the "$" with nothing, find and replace the "," with nothing, and find and replace the ".00" with nothing. When I do find and replace for the ".00", it will ONLY remove the .00 from my dollar amounts that are over $1,000. So anything less then $1,000, such as $750.00, it will not remove the .00. Below I have included step by step screenshots to help illustrate the problem. Like I stated, I have no idea how to fix this and any help would be greatly appreciated.
Conversion issue 1.JPG
Conversion issue 2.JPG
Conversion issue 3.JPG
Conversion issue 4.JPG
Bookmarks