[libreoffice-users] Percentage with bracket as negative

Hi,
I want to use feature Insert - Sheet from file and i have file.txt that
contains like this:
|     1|03/10/2015|14-1403837|SARIPAH                  |  24 |Rp
130,000,000 |Rp     3,799,530|Rp        0|Rp     1,600,000|
 0.0%|Rp   36,296,000|Rp    6,929,000|Rp   130,000,000|Rp             0| 0
     0| (24.86 % )|Arr|    JAMES BOND |Y     |
|     1|02/10/2015|17-2202200|MAKMUR                   |  24 |Rp
 25,060,000 |Rp       828,800|Rp        0|Rp     1,600,000|
 0.0%|Rp    6,452,000|Rp    1,313,000|Rp    25,060,000|Rp             0| 0
     0| (25.24 % )|Adv|       ALEXANDER |Y     |

How to make LibreOffice can detect these (24.86 % ) and (25.24 % ) as
negative percentage value?

I already try many way, but still can not make it read as negative
percentage value.

Please help.. thanks!


Best Regards,
Yudi Wijaya

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted