Share via

TEXT() function sensitivity to separators

Anonymous
2023-09-28T13:58:48+00:00

I have a formula that I would like to be sensitive to the decimal and thousands separators. A simple such formula looks something like this in English:

="The result is " & TEXT(A17, "#,##0")

Now, I'm adding localization, courtesy of some custom LAMBDA functions I wrote. The same formula looks something like this:

=GetLocaleString(RESULT_IS) & TEXT(A17, GetLocaleString(INTEGER_FORMAT))

The strings associated with RESULT_IS and INTEGER_FORMAT vary from language to language.

I would prefer not to have to figure out the format for each and every language, especially when there are variations within languages. What I would really like is a format that is sensitive to the separators that Excel is using, whether they come from the system or are overridden in "Options | Advanced". For the life of me, I can't find anything like that. Does such a format exist?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

6 answers

Sort by: Most helpful
  1. Anonymous
    2023-09-28T23:54:38+00:00

    That goes from text to numeric. I need to go the other way.

    Was this answer helpful?

    0 comments No comments