Cell formats 0.0\% and 0.0%;(0.0%)
We needed a way to force Excel to show the % next to a number without dividing it by 100 You know, when you format...
When Excel tells you to go get some life
This is what happens when you spend too much time in Excel Go have a break and get some life...
Shades of gray
We need this to be documented s8mewhere So, here it is...
Recover the unrecoverable
Working a lot with Excel means seeing lots of errors and bugs inside Excel Some of those are not likely bugs, but more like reaching...
Scorring, saving multiple outputs in 1 number
I have seen this practice before several locations Returning multiple outputs in 1 single number. for example...
Expenses calendar, FaCal
Expenses calendar, to show when in a month you need to pay what bill An easy formula-only smart sheet to allow you get hold on...
Custom fiscal year calendar (CFlex)
Fully customized Yearly Calendar to show certain dates with certain format using conditional formatting, like mark 8th business day each month with certain color, 1st...