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
Cindy M. - 04 Sep 2006 14:52 GMT
Hi Swayze,
> I wrote an app (c# 1.1 framework) that formats excel files generated
> from html.
[quoted text clipped - 9 lines]
> worksheets or workbooks as to override so-to-speak the computer
> settings, but ive googled and cant find anything.
Since you haven't received a response here, you might try in the
excel.programming newsgroup. They've a generally tendency to be allergic
towards anything .NET, especially C#, but there are a couple of people
there with a strong localization background; look especially for Stephen
Bullen. State the localization problem first, then add you're automating
through a .NET interface at the end, so that their heads first start
working on the actual problem...
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
swayze - 04 Sep 2006 16:07 GMT
Hi Cindy,
Thanks for the heads up.
Swayze
> Hi Swayze,
>
[quoted text clipped - 27 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)