# \[bug\] Concatenate() formula functionality differs from + operator overload **URL:** \ **Category:** Ask the Community\ **Created:** [November 19, 2021, 1:01am UTC](https://connect.superhuman.com/t/bug-concatenate-formula-functionality-differs-from-operator-overload/26983 "2021-11-19T01:01:42Z")\ **Posts on this page:** 1\ **Showing post:** 3
**Author:** ![Nick\_HE](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/nick_he/32/6190_2.png) [@Nick\_HE](https://connect.superhuman.com/u/Nick_HE)\ **Post date:** [November 19, 2021, 2:34pm UTC](https://connect.superhuman.com/t/bug-concatenate-formula-functionality-differs-from-operator-overload/26983/3 "2021-11-19T14:34:19Z")
I’ve been caught by this too. Here are a couple other threads if you want some more details, but you can also just obey Paul’s TL;DR of the situation. > [@String concatenation failure](https://connect.superhuman.com/t/string-concatenation-failure/20423): > > The following formula: ":"+"004" returns the string ":4" All zeros are gone. What happened? Meanwhile, I use the workaround: Format(":{1}","004") > [@Leftpad doesn't work when concatenating with "+" (and number-like strings are converted to numbers)](https://connect.superhuman.com/t/leftpad-doesnt-work-when-concatenating-with-and-number-like-strings-are-converted-to-numbers/20475): > > When you concatenate a string using + instead of concatenate(), LeftPadding is ignored: In fact, this led me to realize that all number-like strings are first forced to numbers before being converted back into strings for concatenation. "Hello" + 007 = “Hello7” (fair enough) "Hello" + "007" = “Hello7” (unexpected) Perhaps this is the intended behaviour, but I certainly find it weird slight_smile --- _[View the full topic](https://connect.superhuman.com/t/bug-concatenate-formula-functionality-differs-from-operator-overload/26983)._