Forum Discussion

Paolo_Cruciani's avatar
Paolo_Cruciani
Copper Contributor
May 29, 2023
Solved

separatori migliaia e decimali - valuta OSX

Salve, con sistema macOS Ventura 13.3 non riesco a modificare il formato valuta con separatore di migliaia e di decimali corretto. Selezionando valuta non riesco a ottenere X.XXX,XX ma solamente X X...
excel
Excel on Mac
  • JKPieterse's avatar
    JKPieterse
    Jun 01, 2023
    OK. I don't have Excel 2021 so I do not know where that option is in 2021. But I expect it should be there. One thing to try is to open the VBA Editor, click View, Immediate pane and type this into it:
    Application.UseSystemSeparators=True
    and press Enter.
JKPieterse's avatar
JKPieterse
Silver Contributor
May 31, 2023
Is the Excel option "Use system separators" unchecked by any chance?
Paolo_Cruciani's avatar
Paolo_Cruciani
Copper Contributor
May 31, 2023

In Excel per MAC non esiste l'opzione "Usa separatori di sistema", o almeno non so dove sia JKPieterse 

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    May 31, 2023

    Paolo_Cruciani It is there alright. See attached.

     

    • Paolo_Cruciani's avatar
      Paolo_Cruciani
      Copper Contributor
      May 31, 2023

      JKPieterse nella mia versione Home & Business 2021 non c'è l'opzione...

      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Jun 01, 2023
        OK. I don't have Excel 2021 so I do not know where that option is in 2021. But I expect it should be there. One thing to try is to open the VBA Editor, click View, Immediate pane and type this into it:
        Application.UseSystemSeparators=True
        and press Enter.

Resources