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!
|