Formulas and functions

%3CLINGO-SUB%20id%3D%22lingo-sub-3073881%22%20slang%3D%22es-ES%22%3EFormulas%20and%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3073881%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CSPAN%3EHi!%20I%20would%20like%20to%20convert%20this%20number%201%2C184893%20in%20this%201%2C18%25%2C%20but%20if%20I%20use%3A%20Number%20Format%20-%26gt%3B%20Percentage%2C%20become%20in%20118%2C48%25.%20Can%20you%20help%20me%3F%20Please%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3073881%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi! I would like to convert this number 1,184893 in this 1,18%, but if I use: Number Format -> Percentage, become in 118,48%. Can you help me? Please

5 Replies

@cirala 

If you want to keep the number as it is, use the custom number format

 

0.00\%

 

Keep in mind that you'll have to divide by 100 if you want to perform calculations with the number.

Alternatively, with 1,184893 in A2, enter the formula =A2/100 in B2 and format B2 as a percentage.

You can then use B2 in calculations directly.

@Hans Vogelaar thanks, but I don't have that option, only these:

Captura de Pantalla 2022-01-27 a la(s) 11.03.41.png

@cirala 

What platform are you on? It should be possible to enter a custom number format in Excel for Windows and for Mac. This is not (yet) available in the online (browser) version of Excel.

@Hans Vogelaar
I have same options in both of them, in online versión and Excel for Windows.
 

@cirala 

This is in Excel for Windows. 0.00\% is not in the list, but I have typed it myself in the Type box:

S1103.png