I need to pad a number with 2 leading zeros to be able to read a legacy bar code. The ToFormattedText function does not actually convert the number so I can't use the PadLeft function. I know there has to be a way to convert a number to text, but I can not seem to find the right function. Any help would be appreciated.
------------------------------
Julie Meeker
------------------------------
Question
Convert a number to text
+8This topic has been closed for replies.
+24How about this as a formula text field.
var text MyBarCode = ToText([my bar code field]);
IF(not begins($MyBarCode, "00"), "00" & $MyBarCode, $MyBarCode)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var text MyBarCode = ToText([my bar code field]);
IF(not begins($MyBarCode, "00"), "00" & $MyBarCode, $MyBarCode)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.