minus sign

  • Thread starter Thread starter tom mcdonald
  • Start date Start date
T

tom mcdonald

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

|
| 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?action=getinfo&userid=24369
| View this thread: http://www.excelforum.com/showthread.php?threadid=534053
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cute trick I just discovered 5
COUNTIF calculates slow (10000+ records) 6
Negative number format 5
display repeating row information in columns 1
Summing the same column from many sheets with specific Row ID numbers 11
Remove Civic numbers in Street Address, move to previous blank cell 1
Extend series 5
Formula for function/argument "exclude". 0

Back
Top