I have this problem, where when I create a preview from an Excel file, the currency format is automatically wrong.
Exactly the problem is as follows:
- I have a Cell with set format to 15, Culture Czech, Value 1500
- In Excel It all looks just fine: “1500 Kč”
- In GridDesktop preview the cell looks all wrong: “Kč1500”, which is incorrect. I suppose that this uses the default Currency format ‘[sign][value]’.
Can I change it anyhow to look as ‘[value][sign]’ ??