This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Formatting a Number in String

Posted on 09-17-2024 11:44 AM
manueurofax
Silver 2
Silver 2
Reply posted on --/--/---- --:-- AM

Hello,
is it possible to set a number in the format: 1 = "001", 2 = "002"?
Thanks for your attention...

Solved Solved
0 5 163
Topic Labels
Jump to Solution
0 Likes
2 ACCEPTED SOLUTIONS

Posted on --/--/---- --:-- AM
Steve
Platinum 5
Platinum 5
In response to manueurofax
Reply posted on --/--/---- --:-- AM

Configure the Number column as above, then use TEXT([Number]) to set the Text column value.

View solution in original post

Jump to Solution

Posted on --/--/---- --:-- AM
manueurofax
Silver 2
Silver 2
In response to manueurofax
Reply posted on --/--/---- --:-- AM

It doesn't work in CONCATENATE(). You have to use a virtual column as suggested and then in CONCATENATE() you find the desired format.

Thanks for your attention...

View solution in original post

Jump to Solution
5 REPLIES 5