Yes your code does work except that I think you missed out to put the "-" sign infront. This is definitely one option I can use - thank you.
ASSIGN BCellValue = "-" + SUBSTRING(BCellValue,1,LENGTH(BCellValue) - 1)
WHEN SUBSTRING(BCellValue,LENGTH(BCellValue),1) =...