Inserting a % sign in an enterprise field

D

Dale Howard [MVP]

Sally --

Presuming you are attempting to use a custom enterprise Number field for
this purpose, you must use a custom enterprise Text field instead. In the
field, you would use the formula you are using in the Number field, and then
add the following at the end of the formula:

& "%"

The ampersand character will add the percent sign at the end of the number.
You must include the quotation marks around the ampersand character, by the
way. Hope this helps.
 
S

Sally

Thanks Dale!
--
Sally


Dale Howard said:
Sally --

Presuming you are attempting to use a custom enterprise Number field for
this purpose, you must use a custom enterprise Text field instead. In the
field, you would use the formula you are using in the Number field, and then
add the following at the end of the formula:

& "%"

The ampersand character will add the percent sign at the end of the number.
You must include the quotation marks around the ampersand character, by the
way. Hope this helps.
Click to expand...
 
Top