Choose Customer as Category, type in 0.00,"K" in the Type: box, click ok
The number of zeros behind the decimal point will decide how much decimal places to show. For example a cell with 2519 typed in will show 2.52k for 0.00, "K" as custom format.
If you need a dollar sign in front, just use $0.00, "K"
No comments:
Post a Comment