2 Replies Latest reply on Apr 5, 2012 4:32 PM by Kaorin

    GetAsNumber - How to retain the "0" when converting the text containing number "01 White"

    Kaorin

      Title

      GetAsNumber - How to retain the "0" when converting the text containing number "01 White"

      Post

      Hi,

      With my little knowlegde of formula, how can I keep the number "0" in the text containing numbers such as below:

      I have a field name called Colour_Code and the texts are "25 Black" and "01 White", and I want to keep the 2 digits at all time.

       

      "25 Red" becomes "25" when I apply:  GetAsNumber(Colour_Code). However,

      "01 White" becomes "1" rather than "01".

      AM I using the wrong formula or is there a number setting that I can adjust?

      Thanks.