Skip to content
REFERENCE

U.CONVERT

Summary

Provides domain-specific conversions of values; currently supports converting tenors to dates (and vice-versa) and restoring CUSIPs parsed by Excel into numbers

Syntax

=U.CONVERT(data, to, [from], [fail_value], [parameter], [parameter], [parameter])

Parameters

Parameter Required Description
data Yes The range containing the values to be converted
to Yes The output type to which values should be converted
[from] No The input type from which values should be converted. If not provided then default assumptions for specified "to" type are applied
[fail_value] No If set then specified value will be returned for values that cannot be converted. If not set then the input value is returned if it the conversion fails
[parameter] No One or more parameters to be provided to the conversion logic
[parameter] No One or more parameters to be provided to the conversion logic
[parameter] No One or more parameters to be provided to the conversion logic

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.CONVERT(C13:C18,"cusip")

=U.CONVERT(B43:B47,"tenor")

=U.CONVERT(B43:B47,"tenor",,,2)

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.