I have a macro that changes the format of cells from general to Accounting with 2 decimals. However if my spreadsheet is imported, I can use my macro but still have to F2 every individual cell to actually change the format.
Is there any other way to do this.. or can I make a macro that will F2 a huge area at the same time? I have tons of records & it would take hours to F2 every cell.
Is there any other way to do this.. or can I make a macro that will F2 a huge area at the same time? I have tons of records & it would take hours to F2 every cell.