Alaska Software Inc. - Format Number for a Column with Euro Symbol and negative sign.
Username: Password:
AuthorTopic: 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 +0100
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.


Doc1.pdf
Jorge L. BorlandoRe: Format Number for a Column with Euro Symbol and negative sign.
on Tue, 13 Mar 2018 12:53:45 -0300
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.
>
=?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 +0100
El 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.