Forum Discussion
currency format Excel 360
Hello KimC1,
If the same column is showing some negative values with a minus sign and others without, I'd first check whether all the cells actually have the same number format.
Select a cell that displays correctly and one that doesn't, press Ctrl+1 on each, and compare the Number format. If they differ, select the entire column, go to Home > Clear > Clear Formats, then reapply a single format to the whole column.
If you want negative values to display without a minus sign, use this custom format:
$#,##0.00;$#,##0.00;$0.00
Keep in mind that this only changes how the values are displayed. The underlying values are still negative, so the status bar Sum and formulas like SUM() will still subtract them.
If some cells continue to behave differently after reapplying the format, check whether those cells are stored as text or whether conditional formatting is overriding the number format or font.
If you're still getting the error after pasting from Notepad, the issue is likely with the forum editor itself rather than the text.