Live it Large with Number Formatting!

Number Formatting

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?

Numbers

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’.

Numbers2

Step 4:

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

Numbers3

Step 5:

Now, enter the following into the box:

Numbers6

Numbers4

Numbers5

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

Neat!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s