Type 09/09/2008 in B2 Click the Home tab. Click the Number Format list arrow. Click Long Date. Check the Result