Text copied or imported onto a spreadsheet may not be capitalized the way you want. Or if several different people work on the same spreadsheet you may get some people typing in all caps while others use normal capitalization. Excel doesn’t have a Change Case button like Word does, but you don’t have to copy your text to Word to change case and copy it back. Excel has three functions, UPPER, LOWER, and PROPER that you can use to change the case of text.
Archive for category All
Memorized Transactions
Nov 29
Peachtree users that repeatedly enter the same or similar transactions can save time and improve accuracy with memorized transactions.
Have you ever been frustrated staring at two lists trying to find the differences between them? Well if you have those lists in Excel it’s a simple job. If both lists are numbers you don’t even need to know any special functions, just subtract the number in one column from the number in the other […]
Have you ever wanted to add up only certain numbers within a list? Maybe it was sales over a certain dollar amount. Or you you have a list of payments and you want to know the total of all payments with a payment type of “Check”. If you only have one criteria for selecting the […]
Sage Drive is a Sage 50c feature that allows you to share your Sage 50 company data with users outside your office. When the feature was first introduced, sharing your data meant that only one user could access that company, no matter how many user licenses you had. Later they improved things a little by […]
This month’s tip is a request from a reader. Ginny wanted me to address “How to write off uncashed checks from prior years and how to handle re-issuing an uncashed check from prior years.” Even though the same principals apply in all three cases, the exact steps will vary depending on whether the check paid […]
Excel Watch Windows
Sep 27
A watch window lets you monitor cells from different parts of a spreadsheet all in one spot.
Hopefully this is a tip you won’t need very often but when a customer does bounce a check, at least there’s any easy way to account for it in Sage 50. It’s basically just two steps: First invoice the customer for the NSF check charge. Second, record a negative cash receipt in the amount of […]
Last month I talked about how you can freeze rows or columns in an Excel workbook so that your headings stay visible on screen. This month I’ll show you how you can choose rows or columns to appear on every page when you print. This lets you print a report heading and/or column/row headings on […]
A few months ago Microsoft released an update to Windows 10 that caused Sage 50 to crash. But you could work around it by setting Sage 50 to run in compatibility mode. Now Microsoft has released a new Windows 10 update that is causing Sage 50 to fail to open when it is set to […]
