Formatting cells: Using the format painter to clear formats

Learn how to use the format painter to remove and clear formatting
Why is it so 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.