Share via

Formatting a number in thousands

Anonymous
2023-03-01T19:02:35+00:00

How do I format a numerical cell that will show the number in thousands. For example, the cell has a number of $1,113,680 and I like it to show the value as $1,114. The cell's content may be a formula or linked by other means (not necessarily a hand keyed number).

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2023-03-01T20:11:38+00:00

    If my true value is $400 the formatting would return a presentation as $0. What formatting would I need to return the presentation as $-

    The following Custom format:

    [<500]$-;$#,##0,

    or adpating the Accounting format, perhaps:

    [<500]$-??;#,##0,

    1 person found this answer helpful.
    0 comments

Answer accepted by question author

  1. Anonymous
    2023-03-01T19:38:25+00:00

    You might use the following Custom format:

    $#,##0,

    Note comma following the zero.

    The cell content does not matter, whether it be a constant, formula or "linked by other means".

    But note that the value of the cell remains 1,113,680, despite appearances.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-03-01T20:29:10+00:00

    Thank you so much again!

    0 comments
  2. Anonymous
    2023-03-01T19:51:52+00:00

    Perfect, thank you so much.

    One more question for this formatting: If my true value is $400 the formatting would return a presentation as $0. What formatting would I need to return the presentation as $-

    0 comments