| 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! |
| 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) | |||
Threaded Mode
