The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that. Image: PixieMe/Shutterstock ...

For instance, you can’t easily sum values in a range based on a format. However, you could accomplish this using VBA. But you don’t need code; you just need a little flexibility.