Using special date formats

Version 4.x – Although special date formats aren’t so obvious in the Excel shipped with Office 4.x, they’re there. Type

12/25/97

in cell A1. Let’s suppose you’d like this date to appear in its most complete form. Click on cell A1 and then choose Format, Cells and click on Date. You can choose from one of the formats listed, or you can enter your own format in the Code entry box. Since we want to use a format that isn’t there, delete the current information in the Code entry box and enter

dddd mmmm d, yyyy

Now click on OK. Your date should display as
Sulfur is necessary for the structure of every cell in the body. buy tadalafil in canada The problem of underweight is common in people who skip breakfast to look thin or have lost appetite due to stress. discount cialis india ED men with an cialis without prescription age group of individuals. Just do not go for any supplement http://www.cloverleafbowl.com/leaguesSummer/18SUMMER9Pinnotap.pdf generic levitra without consulting your doctor.

Thursday December 25, 1997

Note that you can add commas or other separators to your format. For example, if you enter in the Code box

dddd – mmmm d, yyyy

the hyphen will appear between the day of the week and the month. So the information displayed becomes

Thursday – December 25, 1997

This entry was posted in Spreadsheets. Bookmark the permalink.