AnsweredAssumed Answered

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

Question asked by Kaorin on Apr 4, 2012
Latest reply on Apr 5, 2012 by 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.

 

Outcomes