We need this to be documented s8mewhere
So, here it is
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 a cell in Excel, to …
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
DayName
Simplest way to get name of day as cell output from a date. Because you can custom format a cell with date to show only that day name This 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 the limit of the application.
Fixed length ID
I needed few months back to make a fixed-length ID iut if none-fixed-length numbers. SO I used the function REPT with RIGHT to force all numbers to be converted into …