+ Reply to Thread
Results 1 to 3 of 3

Cell formating; One decimal for values smaller than 2000

  1. #1
    Registered User
    Join Date
    03-14-2016
    Location
    Stuttgart, Germany
    MS-Off Ver
    MS Office 2010
    Posts
    1

    Cell formating; One decimal for values smaller than 2000

    Hello everyone,

    I got the following problem: I use #. "k" as formating for my cells. This means 921->1 k, 421->0 k. However I would like to have the formating in a different way: 921->0,9 k, 421-> 0,4 k. Values bigger than 2000 (2 k) however should be displayed as before (2021->2 k). How can I implement the desired changes?

    Thank you very much!

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: Cell formating; One decimal for values smaller than 2000

    Not completely what you want but maybe it is enough
    Try this format:
    0,0."k"
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Cell formating; One decimal for values smaller than 2000

    Quote Originally Posted by nils1401 View Post
    I use #. "k" as formating for my cells. This means 921->1 k, 421->0 k.
    That is not the result I get with that format.

    I suspect that your best bet will be to use formulas to achieve the formatting you want, rather than using a Custom Format.

    custom formatting k.jpg
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formating Decimal values
    By kjxavier in forum Excel General
    Replies: 7
    Last Post: 10-11-2014, 03:22 PM
  2. Displaying larger values with smaller values in a Column Chart
    By Max9 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-20-2010, 11:59 PM
  3. Count cells with values smaller than a given cell
    By Joel_FH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2009, 02:47 PM
  4. Problem with decimal places in excel 2000?
    By raych in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-26-2007, 07:01 PM
  5. [SOLVED] Formating decimal numbers
    By Rafael in forum Excel General
    Replies: 1
    Last Post: 04-11-2006, 11:25 AM
  6. Formating decimal numbers
    By Wagner in forum Excel General
    Replies: 0
    Last Post: 07-19-2005, 05:05 AM
  7. Formating decimal and date
    By Rick in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2005, 02:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1