mkeen
5 years agoContributing User
Using large credit to settle small sale
Hi I have a large credit of $1,300 and want to settle this against a new sale of $500. Of course this will show an unbalanced amount of $800 still in credit. How do I enter this so the $1,300 c...
- 2 years ago
Hi paddyr , Excel puts quotes around amounts with commas when it saves as text, so I suggest you format the amount column as general (or as number with 2 decimal places but NO commas) before you save it as a txt file.