Home All Groups Group Topic Archive Search About

Excel numberFormat AND localization

Author
31 Aug 2006 1:37 PM
swayze
Hi All,

I 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

AddThis Social Bookmark Button