Hello all!
My problem is that we receive fairly large spreadsheets from different users and they all like to follow different numerical formats. However we need them to be in standard style for later upload. Some user like to use commas, some use spaces and some use decimals as to indicate number breaks like below
2000
2,000
2.000
2 000
What I'm trying to do is write a macro code that will search for decimals in each of the sheets in a workbook (the others will be caught with other later processes) and report to the user when they are found. There will be some text in the document as well so I can't just search for "." unless I can ignore any results that have text in them.
Ideally it would show a pop up with something like "decimals found on sheet 2".
what do you think? If any of of the excel geniuses can whip out some code that would be great! but at this point I'll take a friendly nudge in a good direction as well.
thanks!
Bookmarks