Nick,

Our apps are web based. Most of our time is spent creating online
reports. The reports use american currency notation. This was
established before I started working for this company. Of course,
coming from Canada, this looked perfectly normal to me. All these
reports can be downloaded as excel files which are auto generated while
the report is rendered to the browser. So now, unfortunately, We cant
ask thousands of turkish users to change their local. So for
consistency, it was imperative (as far as management was concerned
anyway) that when users opened the files the same standard was beeing
used as is on the web. Fortunately, all calculations are already done
on the server so excel just needs to display the numbers.

But I definetely agree with you, when writing an app for a specific
culture, one should use the country's culture.

regards,

Swayze


NickHK wrote:
I'm sure you're following the requirements, but if they want the number to
look a certain, why don't they change their settings to reflect that.
I'm not having a go at you... more it seems a case of the user saying
"Doctor, it hurts when I do this."

NickHK

"swayze" wrote in message
oups.com...
Thank you all for your help,

Nick - customer is always right ;)

I eventualy manualy formated the numbers and added a single quote to
the beggining of every number so that excel would treat it as text.
solved my problem.

regards

Marco

Harald Staff wrote:
"NickHK" skrev i melding
...
Swayze,
To me though 1,025.253 should look as I decide according to my
locale/regional settings. I would not want that value represented as
1.025,253 or some variation which may be meaningless or confusing to
me.
So Excel is displaying correctly ; as the user desires. It is value
that
is
required for any calculation, not its appearance.
Or am I missing something ?

Probably only "the customer is always right" <g I agree fully with you
Nick, but sometimes we just have to.

Best wishes Harald