Hide

Formatting cells:
Using the format painter to clear formats

You can download here the worksheet from this video to practice it by yourself!

When is it useful?

It is the fastest way to get your data back to its “raw” format. Then you can leave it that way, or try and format it better.
It can be a real lifesaver when you have numbers formatted in a wrong way: Sometimes numbers appear by mistake as currencies, or even worse - as dates.
The best and fastest way to cancel these wrong formats and bring them back to normal (to appear as simple numbers) is by following these steps:

  1. Right-click an empty cell, an untouched cell.
  2. Click the format painter.
  3. Select the cells which you want to clear their formats.