Microsoft KB Archive/51539

From BetaArchive Wiki

Excel: Changing Serial Number Date to Text Date Format

Last reviewed: November 2, 1994
Article ID: Q51539


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


For example, the following will enter the date specified by the serial number in "value" as text, in the format 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


Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.