You are viewing limited content. For full access, please sign in.

Question

Question

Need to Display 01 instead of 1

Version 10 Forms
Updated September 18, 2017
asked on September 18, 2017

We use 2-digit revision levels (easier for sorting) for our documentation. I have created a hidden field that I will be using to "revise" the document. The field is called revisedRevision:

This issue is that I would like it to display as "01". I tried this, but it didn't work:

Thoughts?

0 0

Answer

SELECTED ANSWER
replied on September 18, 2017

Hi Gloria,

Would it work for you to concatenate the 0 onto the front of the number, like this:

=CONCATENATE("0", SUM(revision, 1))

~Rob

2 0
replied on September 18, 2017 • Show version history

Perfect! Thank you!

0 0
replied on September 18, 2017

No problem!

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...