Posts by tomlon

    My manufacturing system extracts negative numbers in an unconventional way (at least for me). For instance -261 it lists it as 00000261- (for positive, it just list 261). It will import into excel (from the text file) into this format. What formula can I write to convert it to -261 when in Excel and extract the leading zeros and move the +/- sign to the front.


    Thanks