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?


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!


Leave a Reply

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

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

Facebook photo

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

Connecting to %s