Question

How to disply the given number in thousands in excel?

Answer 1

Ways of displaying thousands and millions

Select the cells which you want to display in thousands.

Open the format cell dialogue by pressing Ctrl + 1 or right-click on the cell and select “Format Cells”. On the “Number” tab, click on “Custom” on the left hand side.

For “Type” write: #,##0,;-#,##0, and confirm with OK.