Spreadsheet Compare application
This is only available in Microsoft 365 Enterprise version, an application that can compare two workbooks in all objects. This includes cells (values or formulas)...
Lesson learned: Do not trust Google Sheets function
It wasted few days, hitting my head at the wall.My mistake …. I trusted that Google Sheets function called GoogleTranslate is working as it is...
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...
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...
Excel Limits
Worksheet and workbook specifications and limits For more limits of VBA inside Excel, check out http://BoldCodes.com/?DevID=26CFPFO4LB Feature Maximum limit Open workbooks Limited by available memory...
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...