|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Excel numberFormat AND localizationI wrote an app (c# 1.1 framework) that formats excel files generated from html. I am using numberFormat ("#,##0.00") on certain columns that display pricing. i am in Turkey but, I use XP pro with regional settings set to Canada. The computers that display these worksheets have localization set to ("tr"). So prices dont display as "10,258.98" like on my pc, they display as "10,258,98" with a comma instead of a dot. the rest of our systems use american currency systems (with the dot) I read somewhere that i can save localization "inside" individual worksheets or workbooks as to override so-to-speak the computer settings, but ive googled and cant find anything. Does anyone have any ideas? Thanks in advance for ANY insight Regards Swayze
Other interesting topics
|
|||||||||||||||||||||||