That's me.
I thought I might be getting to the "toddling" stage in this VB, but no - back to crawling.
I have a column of data that has been screen dumped from a mainframe. It is mainly all numbers, with some cells being blank or having hyphens etc in them.
The numbers have been written as 2 345 678.00DB to indicate debit entries, and to indicate credit entries it is just the number, no minuses or anything like that.
It is not a problem to get it all into number format etc etc, but what I can't work out is how do I turn the credits (numbers without any trailing letters) into a number having a "-" at the front of the number that M/Soft will accept as a legitimate negative number? Doing text to columns etc doesn't work, it needs to be script driven.
Pls point me in the right direction?
Thanks & take care
Amanda