![]() For example, the formula =TEXT(F1+F3,"mm/dd/yyyy") would produce the text. In the formula, you can use the TEXT function to convert a date or a number into text with a particular numeric format. Strategy: Excel internally stores dates as numbers and relies on the number format to display the number as a date. As you can see in cell B13, when I attempt to join both date and currency with text, the currency loses the dollar sign and the date appears as a strange number. Problem: I just learned about concatenation, and I'm trying to join text with currency and with a date.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |