Home |
Search |
Today's Posts |
#1
|
|||
|
|||
moving minus sign from right to left
I have worksheet that has "-" on the right side of the number
14.59- 45.99- I have used =IF(RIGHT(J2,2)="-",-SUBSTITUTE(J2,"-",""),J2) which logical test should return "True". However, it is returning "false" for all of the numbers. even with ones without "-" on the right. I have text column to "General", "number" and "Text". help! Thank you! |
#2
|
|||
|
|||
Take a look he
Convert trailing minus signs http://www.mcgimpsey.com/excel/postfixnegatives.html In article , "GEORGIA" wrote: I have worksheet that has "-" on the right side of the number 14.59- 45.99- I have used =IF(RIGHT(J2,2)="-",-SUBSTITUTE(J2,"-",""),J2) which logical test should return "True". However, it is returning "false" for all of the numbers. even with ones without "-" on the right. I have text column to "General", "number" and "Text". help! Thank you! |
#3
|
|||
|
|||
You are testing to see if 2 characters are equal to a single character.
That's rather unlikely to ever be true. Try using RIGHT(J2,1) ="-" instead "GEORGIA" wrote: I have worksheet that has "-" on the right side of the number 14.59- 45.99- I have used =IF(RIGHT(J2,2)="-",-SUBSTITUTE(J2,"-",""),J2) which logical test should return "True". However, it is returning "false" for all of the numbers. even with ones without "-" on the right. I have text column to "General", "number" and "Text". help! Thank you! |
#4
|
|||
|
|||
Hi Georgia,
copy this fomula and it will work =IF(RIGHT(j2,1)="-",-SUBSTITUTE(j2,"-",""),j2) Your idea was close but not quite. Hope this helps Rgds, Dave "GEORGIA" wrote: I have worksheet that has "-" on the right side of the number 14.59- 45.99- I have used =IF(RIGHT(J2,2)="-",-SUBSTITUTE(J2,"-",""),J2) which logical test should return "True". However, it is returning "false" for all of the numbers. even with ones without "-" on the right. I have text column to "General", "number" and "Text". help! Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
strip minus signs from right to left | Excel Discussion (Misc queries) | |||
Align $ sign next to numbers | Excel Discussion (Misc queries) | |||
I want to get brackets round my figures not minus signs | Excel Discussion (Misc queries) | |||
moving mouse highlights cells without touching left mouse button | Excel Discussion (Misc queries) | |||
minus formel/fortegn | Excel Discussion (Misc queries) |