# Number Bug in formula

**URL:** <https://connect.superhuman.com/t/number-bug-in-formula/11489>\
**Category:** Bugs\
**Created:** [October 22, 2019, 10:44am UTC](https://connect.superhuman.com/t/number-bug-in-formula/11489 "2019-10-22T10:44:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kent\_Watson](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/kent_watson/32/10829_2.png) [@Kent\_Watson](https://connect.superhuman.com/u/Kent_Watson)\
**Post date:** [October 22, 2019, 10:44am UTC](https://connect.superhuman.com/t/number-bug-in-formula/11489/1 "2019-10-22T10:44:22Z")

</div>

I have the following formula however the space is ignored

> [State]+If(IsBlank([Post Code]),“”," "+[Post Code]

Even though the column type for Post Code is text, if I enter a numeric value e.g. 1234 there is no space

The result I end up with is QLD1234 instead of the expected QLD 1234

---

<div class="post-metadata">

**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\
**Post date:** [October 22, 2019, 12:35pm UTC](https://connect.superhuman.com/t/number-bug-in-formula/11489/2 "2019-10-22T12:35:10Z")

</div>

Hi @Kent_Watson 🙂 ! Welcome 😁 !

Could you try this 🙂 :

`Concatenate([State],If(IsNotBlank([Post Code]),Concatenate(" ",[Post Code]),""))`

---

<div class="post-metadata">

**Author:** ![Kent\_Watson](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/kent_watson/32/10829_2.png) [@Kent\_Watson](https://connect.superhuman.com/u/Kent_Watson)\
**Post date:** [October 22, 2019, 11:51pm UTC](https://connect.superhuman.com/t/number-bug-in-formula/11489/3 "2019-10-22T23:51:31Z")

</div>

thanks @Pch  
I found another issue where I wanted to LeftPad a number with zeros e.g. 000001, basically the full result I was looking for was ABC-19-000001. but my code would always remove the preceding zeros. I ended up using a different character and doing a regex replace but I might try with the concatenate because that is supposed to be text then right?

---

<div class="post-metadata">

**Author:** ![Kent\_Watson](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/kent_watson/32/10829_2.png) [@Kent\_Watson](https://connect.superhuman.com/u/Kent_Watson)\
**Post date:** [October 22, 2019, 11:54pm UTC](https://connect.superhuman.com/t/number-bug-in-formula/11489/4 "2019-10-22T23:54:08Z")

</div>

Yep just tried the concatenate and it worked as I expected. Thanks.