I have attached a spreadsheet. If the format of the cell in B2 is what you are looking for use the format painter to copy it to the desired cells on you spreadsheet. If this does not work I am out of ideas. Good luck