Excel: Legs, Eggs and Pigs Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Home -> Number

Format Date and Time

2. Select cell A2 and enter the date. Please type: 6/1/07. What do you see? The default format for date changed your display to 1-Jun-07.

 

Look on the formula. In the sample screen on this page, it reads exactly the way it was typed.

 

The FORMAT in cell A1 displays  d/m/yy. This is formatting, the same way text can be formatted big, bold and colorful. The DATA is what you see in the Formula bar.