I am attempting to combine a fixed text string and two number fields into a formula field. The fields from the form are Number and joblist. Number is calculated as the greatest value of number +1, while joblist is a lookup field for job number. I used the following code:
"H13" + Number + "-" + joblist
The formula result is:
H133614-1619928000000252808
Everything to the left of the dash is correct, the number to the right should be five digits and is nothing like what is represented.
Thanks for helping the newbie again.