Trick of the day: Format Painter

If you want to copy the format, but not the values, from another cell, use the Format Painter. Select the cell that has the format you want to copy and click here:

Then, click on the cell that you want to format. If you want to copy a format into multiple cells, double-click on the Format Painter icon. Press escape to deactivate it when you're done.

More on this: http://xl-easy.blogspot.se/2012/11/copy-format-in-excel.html