I format a column for accounting and it works properly so that all numbers in that column take on an accounting format. When I format the next column over to "percentage" is changes the formatting on the first column over to "percentage". When I change the first column back to "accounting" it changes the second column over to accounting. What is going on here?
