How do I change all negative numbers to positive?

Ctrl F -> Find and Replace - with blank space

Regards

A.Kamalarajan

Let's say the amounts are in column D, from D2 down.

In another column, in row 2, enter the formula =ABS(D2)

Fill down to the last used row.

Use the new column where you need the values without the minus signs.

Hi Frithe J, I'm Femi and I'd be happy to help you with your question. Yes, you can change the appearance of negative numbers to positive in Excel. Here's how you can do it: Open your Excel spreadsheet that contains the imported bank statement data. Select the column that contains the debit amounts. Right-click on the selected column and choose "Format Cells" from the context menu. In the "Format Cells" dialog box, go to the "Number" tab. In the Category list, select "Number." In the "Negative numbers" section, choose the option "2 -1,234" or any other format that doesn't display negative numbers. Click on the "OK" button to apply the formatting. After applying these steps, the numbers in the selected column that were previously displayed as negative (debit amounts) will appear as positive values.

Please note that this formatting change doesn't affect the actual values or calculations in Excel; it only changes their visual representation.

Hope this helps!

Best Regards, Femi

Hello,

Create a separate column and in the first cell use =IF(A3>0,A3,(-1*A3)) where A3 is the first cell of the column to be converted. Drag the cell down to replicate it for the full new column.

How will you distinguish credit form debit?

If it is just for display purposes, select the column and apply the following custom number format:

$#,##0.00;$#,##0.00

Negative values will still be negative, but the - will not be displayed.