After yet another one of the lovely Office updates my excel Comma formatting changed. Now when I click on the comma to format a column of numbers, instead of putting my negative figures into brackets, it puts a minus in front, but with a massive gap between the number and the minus.
So now I have to CONSTANTLY change the format of the numbers.
Is there no way I can change the default setting of what happens when I click on the Comma? Before this thing drives me bonkers?