Microsoft KB Archive/51539

{| = Excel: Changing Serial Number Date to Text Date Format =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q51539

SUMMARY
To convert a serial date number, such as 31182, to an actual text date, such as &quot;5/16/89&quot;, use the TEXT function as follows:

=TEXT(value,&quot;format_text&quot;) For example, the following will enter the date specified by the serial number in &quot;value&quot; as text, in the format m/d/yy: =TEXT(value,&quot;m/d/yy&quot;) 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).
 * }