Microsoft KB Archive/95763

= Microsoft Knowledge Base =

Exel: Info_Type with Gives Incorrect Result in CELL Function
Last reviewed: September 12, 1996

Article ID: Q95763

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0 and 4.0a
 * Microsoft Excel for the Macintosh, version 4.0

Page 47, of the &quot;Function Reference,&quot; version 4.0 incorrectly describes text values that the CELL function will return for a series of custom date formats with an info_type of format.

When you apply any date format to a cell other than a built-in format, the CELL function will return a &quot;G&quot; (indicating the General number format) for the following custom date formats:

mm/dd/yy dd-mmm-yy dd-mmm mm/dd The &quot;Function Reference&quot; implies that the CELL function will return D4, D1, D2, or D5 for these formats. This information is incorrect.