| Author | Topic: Format Number for a Column with Euro Symbol and negative sign. |
|---|
 | César Calvo | Format Number for a Column with Euro Symbol and negative sign.
on Sat, 24 Feb 2018 22:33:04 +0100Hello guys.
I am trying to put a column like you can see in the attachemnt file.
If I write
oSheet:Columns(3):NumberFormat = "#.##0,00 ;[Rojo]#.##0,00 " + chr(213)
It visualized the euro symbol only for positive values.
And if I put
oSheet:Columns(3):NumberFormat = "#.##0,00 €;[Rojo]#.##0,00 " + chr(213)
This is visualized
12,00 0,00 €
-12,00 0,00 €
Could anybody say me the correct way?
Thanks in advance.
César Calvo.
 Doc1.pdf |
| Jorge L. Borlando | Re: Format Number for a Column with Euro Symbol and negative sign.
on Tue, 13 Mar 2018 12:53:45 -0300Hi César, try with
oSheet:Columns(3):NumberFormat = "€#.##0,00;[Rojo]-€#.##0,00"
Regards
"César Calvo" <ccalvoc@telefonica.net> wrote in message
news:6a2cf308$35992cd6$1d7789@news.alaska-software.com...
> Hello guys.
> I am trying to put a column like you can see in the attachemnt file.
> If I write
> oSheet:Columns(3):NumberFormat = "#.##0,00 ;[Rojo]#.##0,00 " + chr(213)
> It visualized the euro symbol only for positive values.
> And if I put
> oSheet:Columns(3):NumberFormat = "#.##0,00 €;[Rojo]#.##0,00 " + chr(213)
> This is visualized
> 12,00 0,00 €
> -12,00 0,00 €
> Could anybody say me the correct way?
> Thanks in advance.
> César Calvo.
> |
| =?UTF-8?Q?C=c3=a9sar_Calvo?= | Re: Format Number for a Column with Euro Symbol and negative sign.
on Sun, 18 Mar 2018 14:22:05 +0100El 13/03/2018 a las 16:53, Jorge L. Borlando escribió:
> Hi César, try with
> oSheet:Columns(3):NumberFormat = "€#.##0,00;[Rojo]-€#.##0,00"
>
> Regards
>
> "César Calvo" <ccalvoc@telefonica.net> wrote in message
> news:6a2cf308$35992cd6$1d7789@news.alaska-software.com...
>> Hello guys.
>> I am trying to put a column like you can see in the attachemnt file.
>> If I write
>> oSheet:Columns(3):NumberFormat = "#.##0,00 ;[Rojo]#.##0,00 " + chr(213)
>> It visualized the euro symbol only for positive values.
>> And if I put
>> oSheet:Columns(3):NumberFormat = "#.##0,00 €;[Rojo]#.##0,00 " + chr(213)
>> This is visualized
>> 12,00 0,00 €
>> -12,00 0,00 €
>> Could anybody say me the correct way?
>> Thanks in advance.
>> César Calvo.
>>
Thanks Jorge.
The problems was in character conversion of Compiler in the XPJ file.
If I set No Conversion it works fine and no if is set ANSI->OEM or
OEM->ANSI.
César Calvo. |
