Share via

Change negative numbers to positive in Excel Office 365

Anonymous
2019-02-12T01:26:04+00:00

I have a column of numbers that have a negative sign. I would like to change them to a positive sign (e.g., -321.55 to 321.55).

Can this be done?

Thanks

Microsoft 365 and Office | Excel | For home | 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
    2019-02-12T01:30:10+00:00

    Hi,

    Simplest way would be to add a column for your result.  Use the ABSolute function.

    Cell B8: =ABS(A8)

    You will only end up with positive numbers. To do it in place would require a macro, I believe,

    I hope this information helps.

    Please let me know if you have any more questions or require further help.

    Regards

    8 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-02-12T02:28:02+00:00

    You are welcome.

    I certainly can't keep track of all the functions.

    When I think there ought to be one, I search. Sometimes I get lucky.

    0 comments
  2. Anonymous
    2019-02-12T01:47:39+00:00

    Thank you very much - wish I'd thought of it!

    0 comments