Hi all!
We got an excell file from our customer. He wanted us to add a 1000 seperator to the amounts, we use . here in Iceland (100.000).
When we add the xls file the seperator from Excell disappears. We apply FormatNumber in rules but we can only add a , "comma" (###,###, 100,000). How can I let Xmpie put a . "point" instead of a , "comma" in the seperator?
We then saved the file as a text file. Then the . comes along but then all the numbers ending with a 0 (zero) after the . dont show the last zero, for instance 63.480 shows as 63.48 in Indesign.
Anyone?
Thanks
Birgir
We got an excell file from our customer. He wanted us to add a 1000 seperator to the amounts, we use . here in Iceland (100.000).
When we add the xls file the seperator from Excell disappears. We apply FormatNumber in rules but we can only add a , "comma" (###,###, 100,000). How can I let Xmpie put a . "point" instead of a , "comma" in the seperator?
We then saved the file as a text file. Then the . comes along but then all the numbers ending with a 0 (zero) after the . dont show the last zero, for instance 63.480 shows as 63.48 in Indesign.
Anyone?
Thanks
Birgir