Forum Discussion

numpkin's avatar
numpkin
Copper Contributor
Jan 22, 2025

French keyboard accounting issue

My Excel document is refusing to format the cells of a row of numbers in French euros format. Anyone have any suggestions on how to fix this?

I have contacted support and just spent an hour on this.

It will not accept the commas which French format uses instead of the decimal point. Even when the version of the app is put into the French language. Format cells using French or euros do not work either.

The only fix seems to be to use decimal points. But this means my software would be incompatible with the Excel file downloads taken from my French accounting system online... the idea of having to change every comma to a fullstop is frankly depressing!! There's gotta be a better way...

  • Rob_Haman's avatar
    Rob_Haman
    Copper Contributor

    Goto Options-> Advanced -> and adjust the settings, Decimal and thousands separator.

     

Resources