Truncate all numbers with 3 decimal places to 2 decimal places & highlight changed numbers in colour
Posted on 2014-03-25
I've inherited a large, somewhat poorly formatted, spreadsheet of communication frequencies. I am looking for a macro that will:
1. Truncate (not round) all numbers that have 3 decimal places down to 2 decimal places
2. If the 3-decimal number ends in "00", then number to be truncated down to 1 decimal place (ie., 135.100 becomes 135.1)
3. All numbers that change to turn the color red.
The cells can contain an alpha numeric mix and often have multiple entries in one cell using line breaks. The line breaks need to be maintained.
Here is a current and revised cell example:
Current cell format:
YYYYY Townname 126.425
Revised cell format:
YYYYY Townname 126.42