We have seen how to add text values to our formulas to convey a clear-cut message to the readers or users. #2 – Add Meaningful Words to Formula Calculations with TIME Format The TEXT function in Excel formula format the calculation (B2*C2) to the format of #, #. Now, we have the proper format of numbers along with the sales values. As shown below, the calculation part applies the Excel TEXT function to format the numbers. There is nothing to worry about we can format the numbers with the TEXT function in the Excel formula. Because they do not have a thousand separators, that would have made the numbers look properly. One problem with this formula is that sales numbers are not formatted properly.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |