Hi, Stacey. Use Copy on a cell that has the format you want, then highlight
the range you want to contain this formatting. Click on EditPaste Special
and select Formats from the choice box that opens. Now, ONLY your format
will be pasted into the cells, leaving your data unchanged.

HTH