Forum Discussion
Michael Bailey
May 21, 2017Copper Contributor
Custom number format
I use Excel 2013 and I regularly create spreadsheets in Latin American Spanish. I have the Spanish Language Pack installed but it does nothing with number formats. In Latin American countries the...
Jens Stolle
May 21, 2017Copper Contributor
Hi Michael,
in Options / Advanced you can set which signs are used for separators. There you can quite easily exchange the , and the .
But its an ExcelSetting and not saved with the Excel-file. Not sure if that already helps you. I have also tried the apostrophe seperator, but even if you set up a user-defined format it still uses the , from the thousands additionally, so you get 1,'000,000.00
Jens