Comments versus Notes
It is official and looks better now, I know it might be confusing, but I liked it so far Excel now has “Comments”, the classic Comments are now called “Notes” …
Blank (isempty) VS “” (null string)
If formula results in “”, then that cell will not be empty.When copy and paste as values, it will not be empty either.VersusWhen we use VBA (Macro command) Range.value = …
Excel keeps converting all cells to “Date” (or Time)
Issue found several times in xls or xlsx, to get it fix https://www.mrexcel.com/forum/excel-questions/637277-excel-converting-numbers-dates.html
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 …