Just been playing around and I may have solved the how to insert (XXX.XX)
into a cell in place of negative numbers IF you did want to see that literal
substituted for a negative number. Simply create a data format using this
String;
###.##;("XXX.XX")
The 'speach marks' are important and I guess that you will need to escape
them in the actual Java code so that the actual String becomes something
like;
###.##;(\"XXX.XX\")
makthar wrote:
>
> HI All
>
> How do i insert the euro symbol in excel sheets.
>
> I tried using [$\u20ac] #,##0.00 but of no use.
>
> what is the difference between $\u20ac and $\u20ac-1. Also how do i tell
> POI that when it renders a negative number it should display it as
> (XXX.XX).
>
>
> Thank You
> Mansoor.
>
--
View this message in context:
http://www.nabble.com/Euro-symbol-using-Apache-POI-tp22046579p22052832.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
