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.
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.
=IF(RIGHT(A1,1)="-",-VALUE(LEFT(A1,LEN(A1)-1)),A1)
--
Kind regards,
Niek Otten
"tom mcdonald" <[email protected]> wrote in message
news:[email protected]...
|
| 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
|
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks