ExcelBanter - minus sign

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - minus sign (https://www.excelbanter.com/excel-worksheet-functions/83935-minus-sign.html)

some cells have numbers like 345- instead of -345, can someone suggest
a function that changes the minus sign around.
PS some cells have more than 3 numbers. Thanks evereyone.

--
tom mcdonald
------------------------------------------------------------------------
tom mcdonald's Profile: http://www.excelforum.com/member.php...o&userid=24369
View this thread: http://www.excelforum.com/showthread...hreadid=534053

=IF(RIGHT(A1,1)="-",-VALUE(LEFT(A1,LEN(A1)-1)),A1)

--
Kind regards,

Niek Otten

"tom mcdonald" wrote in message
...
|
| some cells have numbers like 345- instead of -345, can someone suggest
| a function that changes the minus sign around.
| PS some cells have more than 3 numbers. Thanks evereyone.
|
|
| --
| tom mcdonald
| ------------------------------------------------------------------------
| tom mcdonald's Profile: http://www.excelforum.com/member.php...o&userid=24369
| View this thread: http://www.excelforum.com/showthread...hreadid=534053
|