This probably never dragged too much attention because it was always there but all of a sudden you're finding that taken-for-granted Short Date because you've been handed down Long Dates that contain too much information on the whole. With your worksheet bustling and your columns many in number, a Short Date format can be a needed input.In this … [Read more...]
Excel FIXED Function – How To Use
The FIXED function in Excel rounds off the input number as per the required decimal places and converts the number to text optionally including the decimal point and commas.The placement of commas and periods used as separators depends on the local language setting. The FIXED function is categorized as a text function in Excel.SyntaxThe … [Read more...]
Excel DOLLAR Function – How To Use
The DOLLAR function is categorized as a text function in Excel. It converts a number to text but in currency format. The currency symbol and format depend on the computer's local language setting.The DOLLAR function also comes with out-of-box rounding capabilities.SyntaxThe syntax of the DOLLAR function is as follows:=DOLLAR(number, … [Read more...]
What is Excel Long Date Format & How to Apply (3 Easy Ways)
Your dataset may be lacking in the wholesome feel of a loaded date, complete with its ammunition of the month and day name. It’s not a nosy preference; while short dates work fine for calculations and all, it’s helpful if once-overs are more meaningful when looking at the month or day.Let’s say a delivery system might want to quickly see if any … [Read more...]
Excel EXACT Function – How To Use
The EXACT Function comes under the category of text functions in Excel. It is used to check two or more text strings, whether they are identical or not.The EXACT function being a case-sensitive function compares both the text values and the character's case and then returns TRUE or FALSE.SyntaxThe syntax of the EXACT function is as … [Read more...]
How to Extract Month from Date in Excel (5 Easy Ways)
With endless streams of data, we keep bouncing back to the same thing; organizing. Because data needs to be discernable and that requires displaying or sorting data differently. Dates may need to be split into days, months, or years for the associated analysis and we're focusing on one chunk of that for now.In this tutorial, you will see a few … [Read more...]
Excel TRIM Function – How To Use
The TRIM function removes all the leading and trailing spaces from a string. In addition to this, it also removes extra spaces between the words within a text, leaving a single space between words. It is mainly used to fix improper spacing in the text.The TRIM function is very helpful when concatenating different sets of data from several cells … [Read more...]
Data Validation in Excel – How to Add, Use & Remove
Having multiple users of a workbook is a perfect brew for a barrel of problems. Imagine anyone having access to editing anything. Your reports will quickly become subject to alteration, human errors, and someone’s quirks.A complete shield against that would be protecting the sheet/workbook. This will lock the sheet/file from any alteration or you … [Read more...]
