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!
Let’s start with some data. What if we needed to format the numbers in a way that multiplies every number by 1,000?
Let’s select the entire column.
Now, right click and you will see a series of options. Click on ‘Format Cells’.
Now, click on the ‘Number’ tab and select ‘Custom’.
Now, enter the following into the box:
Now, all the numbers have been automatically multiplied by 1,000!