| View previous topic :: View next topic |
| Author |
Message |
Mr.Ioes
Guest
|
 Posted: Mon Jun 28, 2004 3:30 am Post subject: OO/SO Calc-Format-Code (€-Formatting) |
 |
|
Hello,
at first i have to say: I can´t speak English. (Google-Translate-)Misunderstandings are not excluded.
I want to format Cac-cells for euro amounts in StarCalc7 (or OO1.1.2), in the order: Euro character - empty - if necessary minus signs (otherwise empty) - empty - amount with 1.000-Point and two rear decimal places.
So far - no problem: [ > 0 ] "? "# ##0,00;[<0 ]"? - "# ##0,00;"? "0.00 .
Now I wish still the euro-symbol to the left and the amount to the right aligned. With M$-Excel 2k I can reach that with the *-sign.
Greeting - Mr.Ioes |
|
| Back to top |
|
 |
Guest
|
| Posted: Mon Jun 28, 2004 3:38 am Post subject: Re: OO/SO Calc-Format-Code (€-Formatting) |
|
|
| Mr.Ioes wrote: | Hello,
at first i have to say: I can´t speak English. (Google-Translate-)Misunderstandings are not excluded.
I want to format Cac-cells for euro amounts in StarCalc7 (or OO1.1.2), in the order: Euro character - empty - if necessary minus signs (otherwise empty) - empty - amount with 1.000-Point and two rear decimal places.
So far - no problem: [ > 0 ] "€ "# ##0,00;[<0 ]"€ - "# ##0,00;"€ "0.00 .
Now I wish still the euro-symbol to the left and the amount to the right aligned. With M$-Excel 2k I can reach that with the *-sign.
Greeting - Mr.Ioes |
|
|
| Back to top |
|
|
Guest
|
| Posted: Mon Jun 28, 2004 3:40 am Post subject: Re: OO/SO Calc-Format-Code (€-Formatting) |
|
|
| Mr.Ioes wrote: | Hello,
at first i have to say: I can´t speak English. (Google-Translate-)Misunderstandings are not excluded.
I want to format Cac-cells for euro amounts in StarCalc7 (or OO1.1.2), in the order: Euro character - empty - if necessary minus signs (otherwise empty) - empty - amount with 1.000-Point and two rear decimal places.
So far - no problem: [ > 0 ] "€ "#.##0,00;[<0 ]"€ - "#.##0,00;"€ "0,00 .
Now I wish still the euro-symbol to the left and the amount to the right aligned. With M$-Excel 2k I can reach that with the *-sign.
Greeting - Mr.Ioes |
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
