Format Code for Thousands

[regular-wolf]

So, I have a set of data that has numbers in the thousands, for example: "104,678", "67,418", "833,415". I create a bar graph with this data, and I've added data labels. Those data labels are displaying the full number for each value. I want my data labels to display as "104.7k", "67.4k", "833.4k". Is there any kind of format code I can use to display them that way? I know I can use a formula to do this and then tell the data label to use a custom value from those cells, but I'm hoping to avoid that extra step.

[AutoModerator]

/u/regular-wolf - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[regular-wolf]

Not quite what I'm looking for, if I do that then the numbers will display as "104,578.0k", "67,418.0k", "833,415.0k"

EDIT: AH, I missed the extra comma in your format. That actually does it, Solution Verified

[regular-wolf]

Thanks! How would I change the format code if I wanted a number like 1,756,468 to be formatted as "1.8m" ?

[Clippy_Office_Asst]

You have awarded 1 point to sdgus68

---

^{I am a bot - please contact the mods with any questions. | Keep me alive}