If the minus symbol is appearing as the last character of the cell value then
use this formula.

=IF(TRIM(RIGHT(A1,1))="-","-"&SUBSTITUTE(TRIM(A1),"-",""),TRIM(A1))

Change the cell reference A1 to your desired cell.

If this post helps, Click Yes!
--------------------
(Ms-Exl-Learner)
--------------------



"wynand" wrote:

please help negative and commas in wrong place