[셀서식] 1/1,000로 표기하기 > EXCEL

을

로 표기하는 방법

​

셀 서식을 아래처럼 지정해주면 됩니다.

​

#,##0.00,"k"; (#,##0.00,"k")

​

​

추가자료:)

This would show your numbers like this:

You can use this technique on both positive and negative numbers.

After applying this syntax, your negative numbers also appear in thousands.

Need to show numbers in millions? Easy. Simply add two commas to the number format syntax in the Type input box.

Note the use of the extra decimal places (.00). When converting numbers to millions, it’s often useful to show additional precision points, as in