Hi Andrea,
I was using an Italian OS with the formats changed to Italian, I thought
at
first your issue was with the comma seperator not displaying.
I now see that the Number formatting in this dialog is broken when
checking
on the comma seperator in the dialog which is weird as it gets set
correctly
in the Format/Cells dialog.
Unfortunately Andrea it looks like this is something that I can't see a
workaround for, I'll escalalte the issue but cannot guarantee when it will
be fixed.
Many thanks for you help!
Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided łAS IS˛ with no warranties, and confers no
rights.
<andrea@[EMAIL PROTECTED]
> wrote in message
news:ee9b559.5@[EMAIL PROTECTED]
> Dear Bob,
>
> you are right, I use OS X 10.5.2 with Italian systems settings (language
> and formats) but I have bought the office in English (mainly because I'm
> used to formulas in English while the italian version have them all
> translated in Italian). With my settings "." is the thousands separator
> while "," is the decimal separator (as in all Continental Europe). Excel
> 2008 in English is able to get the correct settings for the numbers
placed
> in the cells. The problems arise when I plot a chart (X Y scatter), add
a
> trend line and display the equation. For sake of clarity let's say that
> the equation is y=0,0421x +36,27 and that I would like only two decimal
> places for both the numbers:
> - I double click on the equation, select number in "format trend label",
> select number in category and 2 as decimal places: I obtain y=000x +036
> - If I then click "use thousands separator (,)", which is obviously not
> read from systems settings and wrong, I obtain y=,04213x + 36,26997.
> Remember I asked to display only 2 decimal places.
> - If I select 0 decimal places I obtain y=,042x + 36,270
>
> SO in the end if I try to have just to decimal places I cannot, plus I
> have a missing 0 in from of the comma
>
> I hope that this time I have been more clear. Thanks for helping me on
> this issue
>
> Best Regards
> Andrea
>
> ps of course I I change setting (both language and number format)
> everything is correct
|
