Aesthetics 2: Formatting Numbers

Number Formatting

Time to learn: 3 minutes

For those of you dealing with large sums of numbers – maybe in a currency that has a lot of zeros in them, here’s something that may help!

Step 1:

Let’s start with some data.  What if we needed to format the numbers in a way that multiplies every number by 1,000?

Step 2:

Let’s select the entire column.

Step 3:

Now, right click and you will see a series of options.  Click on ‘Format Cells’.

Step 4:

Now, click on the ‘Number’ tab and select ‘Custom’.

Step 5:

Now, enter the following into the box:

Now, all the numbers have been automatically multiplied by 1,000!

Neat!