GreatOffender
Board Regular
- Joined
- Feb 2, 2015
- Messages
- 56
I have posted this on another board but I am now on a time crunch so I am grasping at straws. I would use a formula but this is something that will be used again and again by persons other than myself. I need to move the "-" from the end of the number to the beginning. I have cobbled together bits and pieces from other boards/threads and my final result lacks a "trim" which I cannot get to work successfully. The end result is always the same "--" in the front.
Any and all help is always appreciated.
Any and all help is always appreciated.
Code:
Sub Fix_Minus_Sign()For Each cell In Range("BE1:BE" & Cells.End(xlDown).Row)
If InStr(1, cell.Value, "-") Then
cell.Value = "-" & Left(cell.Value, Len(cell.Value) - 1)
End If
Next
End Sub