Am 07.10.2015 um 19:49 schrieb Yudi Wijaya: > 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 >
Always turn on "special numbers" option. This will also import correct dates. -- To unsubscribe e-mail to: users+unsubscr...@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