Microsoft KB Archive/294754

= XL2002: Excel Converts The Letter &quot;B&quot; to a Number When Used in Custom Date Format =

Article ID: 294754

Article Last Modified on 1/6/2006



This article was previously published under Q294754



SYMPTOMS
When you use the letter &quot;B&quot; in a custom date format, Microsoft Excel converts the letter to a number in the formatted cell.



CAUSE
The letter &quot;B&quot; is used a prefix in the Hijdri calendar that some Arabic countries use. Therefore, if you use &quot;B&quot; as a prefix in a date format, Excel adjusts the date to display the year according to the Hijdri calendar.



RESOLUTION
To use the letter &quot;B&quot; in a date format, enclose it in quotation marks when you create the custom format. For an example of how to do this, follow these steps:  In cell A1, type 6:00 . Select cell A1. On the Format menu, click Cells. In the Format Cells dialog box, click the Number tab. In the Category list, click Custom. In the Type box, type the following custom format:

&quot;B&quot;\/[h]:mm

 Click OK.

Cell A1 displays B/6:00.

Keywords: kbnofix kbprb KB294754

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.