Neutralize the Excel format when pasting
1. Neutralize the Excel format when pasting In Sage, sometimes a pasted format from Excel (currency, comma, space) can cause problems. Before pasting: Make sure your cell is in Simple Number format (in Excel: right-click → Format Cells) Avoid the formats "€", "TND", etc. 2. Automate with a small VBA script If you have some familiarity with Excel, you can create a small VBA button to automatically copy the value of a selected cell: vba Sub CopyValue() Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues End Sub This eliminates formulas with a single click. 3. Expected Result You get a smooth process: copying amounts without bugs or misinterpretation. No more restarts or formulas pasted in place of numbers. You save time, avoid accounting risks, and make your export to Sage easier.
No comments yet