A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
That goes from text to numeric. I need to go the other way.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
That goes from text to numeric. I need to go the other way.