Excel: Changing Serial Number Date to Text Date FormatLast reviewed: November 2, 1994 |
SUMMARYTo convert a serial date number, such as 31182, to an actual text date, such as "5/16/89", use the TEXT function as follows: =TEXT(value,"format_text") For example, the following will enter the date specified by the serial number in "value" as text, in the format m/d/yy: =TEXT(value,"m/d/yy") Note: In cases where the date should be a number, rather than a text string, choose Number from the Format menu to format the number to the date format desired (for example, m/d/yy). |
KBCategory: kbother Last reviewed: November 2, 1994 |