VideoPhoto

24 September, 2021

Data entry tips: Formulas and Dates

You might learn from some sources that when you enter a formula into a cell in Excel, you have to start your entry always with the equal sign. This is not true. You can, but DON'T NEED to start with the '=' sign.

Each formula can be started also with either '+', or '-' (if you mean negative number/expression) signs. When you press the ENTER key, Excel will voluntarily add the equal sign for you.

Here are couple of examples to illustrate what happens:

 

Similarly, entering dates (especially multiple dates) into your worksheet cells can be made easier/faster by following these exemplary patterns:

Just make sure that you get values you intended to enter. Please note that you must format cells in column C to your own formatting pattern. I've used my custom date format: dd-mmm-yy.



No comments:

Post a Comment

All comments are held for moderation. I reserve the right to edit, censor, delete and - if necessary - block comments.