Feedback by UserVoice

Franz Verga

My feedback

  1. 36 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Franz Verga supported this idea  · 
  2. 50 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Franz Verga commented  · 

    Just to clarify. At the moment the formatting codes to be used in formulas depend on the Country/Time settings of the OS and not on the language of Excel. And this gives the problem described above. If they would be derived from the language settings in Office, this problem would never arise.

    An error occurred while saving the comment
    Franz Verga commented  · 

    @Roy: I know that we are talking about the same stuff...
    The point is that, at the moment, the formatting codes are not according the language settings in Office (Excel), but according to the Windows settings... So, because I have Italian settings for place and time in Windows, I have to use in Office (Excel), the Italian formatting codes, otherwise the formula doesn't work. When a colleague of mine with his/her German settings (I live and work in Germany...) opens my file, he/she will see a wrong result, tipically gggg, in the case of the formula of my original post....

    An error occurred while saving the comment
    Franz Verga commented  · 

    @Roy: I'm using Excel in English, but in Windows I have the Italian language settings, so, the formatting codes I see in Office (Excel) are the Italian ones: when I create a formula that uses the formatting codes, I am forced to use the Italian ones, no choice.
    The point is that when I share my file with colleagues that have different language settings in Windows (English, German, Spanish, it doesn't matter), the formatting codes inside the formula will not be recognized and the formula will show only the formatting codes...
    This is the background of my proposal.
    A the very end, it's not that important if my colleagues see the formatting codes in the language they have set the preferences for time in Windows.
    For me it's important that the formula works properly, not depending on the language preferences...

    An error occurred while saving the comment
    Franz Verga commented  · 

    @Roy: I think that something like that already happens, because when you want to format a date, for example, the formatting codes are already translated accordingly to the language settings of Windows (not of Office), but this translation doesn't happen in formulas, so opening a file where such a formula was written with different Windows language settings will give the problem...

    Franz Verga shared this idea  · 
  3. 65 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Franz Verga supported this idea  · 
  4. 42 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Franz Verga supported this idea  · 
  5. 477 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hi Ken,

    Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

    thanks
    ash [MS XL]

    Franz Verga supported this idea  · 
  6. 59 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Franz Verga supported this idea  · 
  7. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Franz Verga supported this idea  · 

Feedback and Knowledge Base