I need to concatenate a bunch of values from different fields to create a string result like this:

`1.5 hours @ $125`

The formula I’m trying to use is

`HowMany & " " & What & " @ $" & Rate~`

I’m able to get everything except the “125” part of that result. The “1.5” part is pulled from a data-entry number field called “HowMany”. It works okay. The “125” comes from a formula field called Rate~ that uses a formula like this:

`VALUE( someNumeral )`

The Rate~ field displays the correct value and moreover is used successfully in a simple math calculation formula. I thought that the VALUE() function converted a text numeral into a number. But when I add the reference to that field (the one that contains “125”), the string concatenation fails.

It doesn’t matter whether I use CONCATENATE() or ampersands.

Any suggestions? At the moment the only thing I can think of is that, for some reason, an entered number value in a number field is somehow flexible enough that it can be used in a concatenation formula, while a calculated result that has been coerced to data type number by the VALUE() function is NOT flexible enough to be included in a text string.

If VALUE() converts a text numeral to a number, Is there a function that does the same thing in reverse?

William