Share via

How do I change multiple cells from ones to thousands?

Anonymous
2023-08-30T16:42:45+00:00

How do I change multiple cells from ones to thousands? I have already highlighted all cells, format cell, custom, type #,##0,;-#,##0 and this is not working. I need to add 3 zeros to all numbers in the cell.

Microsoft 365 and Office | Excel | For business | 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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2023-08-30T16:44:54+00:00

    Enter 1000 in an empty cell.

    Select that cell and copy it,

    Select the range of cells whose values you want to multiply with 1000.

    Right-click in the selection.

    Select Paste Special... from the context menu.

    Select Multiply.

    Click OK.

    Clear the cell in which you entered 1000.

    30+ people found this answer helpful.
    0 comments
  2. Anonymous
    2023-08-30T16:58:33+00:00

    Add a help column. Then copy that column and paste as value. Remove the help column.

    =A2*1000

    If you don't want to change the value in cell and show the value with 000 at the end of your value.

    You may set format to

    0"000"

    The easiest way is multiply 1000 directly as Hans suggested.

    3 people found this answer helpful.
    0 comments
  3. Anonymous
    2023-08-30T16:53:45+00:00

    You are such a blessing; I have been trying to figure this out for at least 2 hours! Thank you times a Million!

    1 person found this answer helpful.
    0 comments