Formatting Issues

%3CLINGO-SUB%20id%3D%22lingo-sub-1963612%22%20slang%3D%22en-US%22%3EFormatting%20Issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1963612%22%20slang%3D%22en-US%22%3E%3CP%3EI%20format%20a%20column%20for%20accounting%20and%20it%20works%20properly%20so%20that%20all%20numbers%20in%20that%20column%20take%20on%20an%20accounting%20format.%26nbsp%3B%20When%20I%20format%20the%20next%20column%20over%20to%20%22percentage%22%20is%20changes%20the%20formatting%20on%20the%20first%20column%20over%20to%20%22percentage%22.%26nbsp%3B%20When%20I%20change%20the%20first%20column%20back%20to%20%22accounting%22%20it%20changes%20the%20second%20column%20over%20to%20accounting.%26nbsp%3B%20What%20is%20going%20on%20here%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1963612%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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?

0 Replies