![]() There can be many situations when we need to check the presence of number or text. Similarly if we want to avoid any calculations for a number it needs to be put as a text.ĬONDITIONS WHEN WE NEED TO CHECK THE PRESENCE OF NUMBER OR TEXT IN A CELL If we need to make anything inactive, such as Date to be non responding to the calculation, we put it as a text. ANYTHING STORED AS TEXT WON’T RESPOND TO ANY STANDARD FORMULAS OR FUNCTIONS BUT SPECIALLY DESIGNED TEXT FUNCTIONS. TEXT IS AN I NACTIVE NUMBER TYPE IN EXCEL. ![]() We can perform the operations on the strings or the characters.Ĭharacters are not limited to A to Z or a to z but many symbols are also included in this which we would see in the later part of the article. Text comprises of the individual entity known as character which is the smallest bit which would be found in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |