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...]
Excel CLEAN Function – How To Use
The CLEAN function comes under the category of text/string functions in Excel. It is used to remove first 32 non-printable characters from the text.Based on the 7-bit ASCII character set, codes starting from 0 to 31 are considered as Non-Printing Control Characters such as horizontal tab, vertical tab, carriage return etc.The CLEAN function is … [Read more...]