If you experience problems with date formats not “sticking,” here’s a sanity-saving technique to make your dates appear in the same format.
Let’s say you had one date showing up as 6/1/2011 and the same date later in the column as 1-June-2011. The secret is Clear Formats. The Clear button is located in the Editing group (on the far right) of the Home tab. Click it and choose Clear Formats. The dates will initially appear as serial number dates, but they will appear in whatever date format you choose in the Number format field, in the Number group, on the Home tab.
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/31349/excel-put-an-end-to-date-formats-not-sticking "