Excel Basic - Use the Format Painter tool to copy the format of a cell - EC-PC

Microsoft Excel – Use the Format Painter tool to copy the format of a cell

<span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start"></span><span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start"></span><span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start"></span><span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start"></span><span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start"></span><span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start"></span><span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start"></span>

EXERCISE

Download the file used in the video.
Copy the formatting used in cell B2 and apply this to the other numbers as shown in the video.
In Sheet2 copy the formatting used in cell B2 and apply this to the other months.
Close the file (you don’t need to save the changes).
Download the exercise file then follow the instructions in the yellow box.