1 Reply Latest reply: May 15, 2014 10:07 AM by Data Kruncher RSS

    Negative Values

    trsutton _

      I have imported data from a pdf file.  The file had numeric amounts and some were a negative value (ie  -134.25).  I needed this field to be 8 characters wide so had not problem padding the front of the field with zeroes, but it did not move the negative sign to the front of the zeroes.  Is there a way to quickly do this?  I am using Monarch 10







      Now shows as





      Need this to show as



        • Negative Values
          Data Kruncher

          Hi Tammy,


          Assuming that your original value is a Numeric field, then building a new Character calculated field using:




          should get you the results that you want.