• 쇼핑몰
  • 커뮤니티
  • 북마크

EXCEL




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

하나를하더라도최선을
2020.02.26 10:57 530 0

본문



45600

45.60k

로 표기하는 방법

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

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

추가자료:)

#,##0,"k"

This would show your numbers like this:

118k 318k

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

#,##0,"k"; (#,##0,"k")

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

118k (318k)

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

#,##0.00,, "m"

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

24.65 m



댓글목록 0

등록된 댓글이 없습니다.