Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Set cell format language #53

Closed
EloHailwidis opened this issue Dec 5, 2016 · 1 comment
Closed

Set cell format language #53

EloHailwidis opened this issue Dec 5, 2016 · 1 comment

Comments

@EloHailwidis
Copy link

EloHailwidis commented Dec 5, 2016

I try to format my cell with an Euro french format, like '1 234 567 890.00 €'. I set the cell numFmt to '# ##0.00 [$€-40C]'. But when I open the sheet I get '1234567 890.00 €'. Change the language to 'French (France)' in the Format->Cell menu seems to do the thing. So, how can I set the language for a cell ?

See the 'Montant' column in this file.
test.xlsx

@EloHailwidis
Copy link
Author

In my case, I wouldn't have too big numbers so I set the format to '# ### ### ##0.00'. It's not very clean but it works...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant