Re: [libreoffice-users] Percentage with bracket as negative

At 00:49 08/10/2015 +0700, Yudi Wijaya wrote:
> I want to use feature Insert - Sheet from file ...
> How to make LibreOffice can detect these (24.86 % ) and (25.24 % ) 
> as negative percentage value?

At 08:24 08/10/2015 +0700, Yudi Wijaya wrote:
> The problem is LibreOffice only recognize 25,24% instead 25.24% (so 
> must use "," than ".")

o Insert your sheet as it is.
o In a spare column, enter:
=VALUE(SUBSTITUTE(SUBSTITUTE(Xn;"%";"");".";","))/100
and copy it down the column.
o Copy the resulting values and paste them back over the source 
values, but using Paste Special ... (or Ctrl+Shift+V) instead of 
ordinary Paste and ensuring that Numbers is ticked but Formulae is not.
o Format the resulting column as Percent.

The formula removes the % signs and replaces dot with comma, leaving 
"(24,86  )" in the case of your first example. The VALUE() function 
converts this text to a number, interpreting the parentheses as 
indicating negative values. Dividing by 100 creates the real value 
required - to be properly displayed when formatted as Percent.

I trust this helps.

Brian Barker


--
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