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: [email protected]
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
