Microsoft KB Archive/51539

From BetaArchive Wiki


Excel: Changing Serial Number Date to Text Date Format

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 "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

KBSubcategory:

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.