The other way to do it by using the CONCATENATE function as shown below:ģ. We wish to display the information as follows: We wish to show some text along with the calculations. We use the old price and the discount given in cells A5 and B5. When we insert the text function, the result would look as follows: With the following data, I need to convert the data to “d mmmm, yyyy” format.
0 Comments
Leave a Reply. |