Problem formating formula field

Hello, I have a formula
ITEM01 & “-”& ITEM02 & “-” & ITEM03
and this is what i get?
But my values are all 2 digit numbers, but for some reason they are all being appended with I_
As shown Bellow?


Any ideas?

Hi @rjp - it sounds like the fields you’re using are Single Option fields right?

Currently, their “internal” name is what’s shown when used in a formula, which is what you’re seeing there actually.

Do you need that field to be a Single-option field?

1 Like

Thanks for reply. Yes it is an option field i have made them into text field and that works but not as clean a solution as i would like,