Hi reader,
Sometimes you are dealing with huge numbers that may be useful to be formatted in thousands or millions but you still want to do calculates on it. In the example bellow you can find the solution:
Lets consider this stock record of a store:
Select the column values you want to format -> right-click in the mouse -> select "Format Cells". Then in "Category" select "Number" with "Decimal places:" as 0 and with "Use 1000 Separator" on:
Now, change "Category" to "Custom", and click on the "Type" box, and do the following to format in:
Sometimes you are dealing with huge numbers that may be useful to be formatted in thousands or millions but you still want to do calculates on it. In the example bellow you can find the solution:
Lets consider this stock record of a store:
Select the column values you want to format -> right-click in the mouse -> select "Format Cells". Then in "Category" select "Number" with "Decimal places:" as 0 and with "Use 1000 Separator" on:
Now, change "Category" to "Custom", and click on the "Type" box, and do the following to format in:
- thousands: "space tab" in your keyboard and insert a "k" inside quote marks (as thousands symbol)
- million: double "space tab" in the keyboard and insert a "M" inside quote marks (as million symbol)
If you want to use currency symbol, just include it inside quote marks (e.g. "M€"):
If you need decimal places, just add them on the "Increase Decimal" button (under "Number" Section):
Bellow my example after formatting:
Hope it makes your spreadsheets easier.
Comments
Post a Comment