"Number" column with added Text

[Jerome_TSC]

Hello Dear Community.

Is this possible, trough any direct formula, (so not usinga second utility column or VC) to have a "Number" with text column...

So being able to launch calculations from this value, and to still show some "Text" info (Like units):

For example I have a "Bandwith" column, where I want to add "Mbps", after the numeric value (for display) but still be able to reference the number for calculations 

1000 Mbps

I could use 2 Column , one with Text and a CONCATENATE(TEXT( formula to reference the other number Column, which could be used for calculations. But if I can only use 1 column it would be great !

thanks and best regards !

[Steve · Accepted solution]

---

@Jerome_TSC wrote:

Is this possible, trough any direct formula, (so not usinga second utility column or VC) to have a "Number" with text column...

---

Nope.

[Suvrutt_Gurjar]

---

@Jerome_TSC wrote:

For example I have a "Bandwith" column, where I want to add "Mbps", after the numeric value (for display) but still be able to reference the number for calculations 

1000 Mbps

---

It is not as user friendly as having a suffix of units but one somewhat intermediate user experience alternative could be to display the units of measure in the column's display name itself such as "Bandwidth (Mbps) " or "Weight (Kgs)" and so on.