This blog is no longer being updated. Please visit my new blog at www.easy-excel.com for an updated version og this post: http://easy-excel.com/?p=715
Sometimes some of the data in a table have the wrong format. Here is an easy way to fix it:
Choose one of the cells with the right format and click on the Format Painter on the Home ribbon.
Select the cells you want to change, and they will get the same format! If you want to change formats in several different arrays, double-click on the format painter and press Escape when you’re done.