Custom Number Field

[mmaxwell8]

I have created a custom field and would like to format with a percent sign.
Is there a way to do this??

 

[John]

I have created a custom field and would like to format with a percent sign.
Is there a way to do this??

mmaxwell8,
The title of your post indicates you want to use a spare number field
for the custom field. Unfortunately number fields can only hold digits
and digit separators (i.e. "," and "."). You can however put pretty much
anything in a spare text field. To add a percent symbol to a text field
just concatenate the string. For example,
Text1 = [Number1] & "%" (assuming the value in Number1 is a decimal)

John
Project MVP