Temporarily Disable Formulas 1 Temporarily Disable Formulas To prevent sums from being dynamic or "active," use: Copy the cell in Excel (Ctrl+C) Then Paste Special → Values (Ctrl+Alt+V then V). This replaces the formula with the calculated value—perfect for Sage! 2 Keyboard Shortcut Tip Save time with this shortcut: Select the cell Press Ctrl+C Press Ctrl+Alt+V, then V, then Enter. You've just pasted the value! 3 Create an Intermediate Column You can add a column dedicated to fixed values in your Excel: Use the =VALUE(A2) function, or simply =A2 if A2 contains a sum. Copy and paste this new column with values only. This is a convenient way to prepare your exports to Sage
No comments yet