Formulas for neutral culture support

You can use the TEXT function to format numerical values as text. This enables you to combine values with symbols. For example, the formula =TEXT(56789,"<#,##0") returns <56,789.

But the specified format is dependent on your regional settings. For example, <#,##0 is in English, or neutral, format. When viewed on a machine with non-English regional settings, the formula =TEXT(56789,"<#,##0") returns <56789,0. The equivalent format on a non-neutral machine would be <# ##0, which returns <56 789 on a neutral machine.

Application Studio provides a number of functions that enable you to convert numbers, and number formats, from and to neutral and non-neutral settings.