There are milion of ways on modifying many cells’ value in single pass using… formula. But, what about a situation, when you need to perform only a single one-time bulk-change of value in many Excel’s cells?
I had a situation when I was preparing some IT project’s budget. Since I am an IT geek then writing amounts in thousands like
1,30k USD was no problem at all. However, this solution had two falls:
- Some accounting freak, having nothing to do with IT, had problems understanding that “k” means thousands
- Cells itself had to use some custom formatting of
##0,00k USDin order to add that damn “k”
Thus, I had to do a one-time recalculation of most of cells in my sheet to multiply their value by 1000.Read More “Batch-change value of thousands of cells in Excel sheet”