2 Replies Latest reply: Jul 3, 2014 8:05 AM by Ashfaq Mohammed RSS

    How format value to show zero at beginning of a value

      Hi

       

      How would I get data to show in the same format as the source data for values that begin with one or more zeros? for example:

       

      invoice numbers, which are alpha numeric, when they start with 0 they are being shown as 2308 instead of 002308, i.e. the zeros at the beginnning are not showing.

       

      How would I format the data to show these please?

       

      I have tried the TEXT(VALUE) as VALUE option but this made no difference.

       

      Thanks.