# Problem formating formula field

**URL:** <https://community.noloco.io/t/problem-formating-formula-field/282>\
**Category:** Ask for Help\
**Created:** [February 18, 2024, 4:22pm UTC](https://community.noloco.io/t/problem-formating-formula-field/282 "2024-02-18T16:22:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rjp](https://avatars.discourse-cdn.com/v4/letter/r/eada6e/32.png) [@rjp](https://community.noloco.io/u/rjp)\
**Post date:** [February 18, 2024, 4:22pm UTC](https://community.noloco.io/t/problem-formating-formula-field/282/1 "2024-02-18T16:22:35Z")

</div>

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?

Result  
I\_05-I\_40-I\_00  
Need  
05-40-00

Any ideas?  
Thanks

---

<div class="post-metadata">

**Author:** ![darragh](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/darragh/32/12_2.png) [@darragh](https://community.noloco.io/u/darragh)\
**Post date:** [February 19, 2024, 8:04am UTC](https://community.noloco.io/t/problem-formating-formula-field/282/2 "2024-02-19T08:04:14Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![rjp](https://avatars.discourse-cdn.com/v4/letter/r/eada6e/32.png) [@rjp](https://community.noloco.io/u/rjp)\
**Post date:** [February 19, 2024, 12:04pm UTC](https://community.noloco.io/t/problem-formating-formula-field/282/3 "2024-02-19T12:04:37Z")

</div>

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,