![]() In the following example, you’ll see what happens if you try to join text and a number without using the TEXT function. This is where the TEXT function is invaluable, because it allows you to force Excel to format the values the way you want by using a format code, like 'MM/DD/YY' for date format. ![]() Unfortunately, when you combine text and formatted numbers, like dates, times, currency, etc., Excel doesn’t know how you want to display them, so it drops the number formatting. You could type that into Excel manually, but that defeats the purpose of having Excel do it for you. Let’s say you want to combine text and a number value, like “Report Printed on: 03/14/12”, or “Weekly Revenue: $66,348.72”. The TEXT function is rarely used by itself, and is most often used in conjunction with something else. ![]() Special formats will be different depending on locale, but if there aren't any special formats for your locale, or if these don't meet your needs then you can create your own through the Format Cells > Custom dialog.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |