WPS - HOW TO CORRECT THE NUMBER AND CURRENCY FORMAT

WPS FORMATO DE NÚMERO Y MONEDA
NUMBER AND CURRENCY FORMAT IN WPS

Deepin It has undergone changes, and in this year 2020 it has taken a spectacular turn with its new look and improvements that have given the end user great satisfaction. Hopefully nothing is perfect, but it continues to evolve by leaps and bounds.

In this tutorial we are going to explain in the simplest, clearest and most concise way how to solve the problem about the format of numbers in WPS. In this version of Deepin, certain things have been corrected for its proper functioning, but certain configurations remain to be resolved and that is what will be resolved at this time.

We have the scenario of when we want to write a number in WPS Spreadsheets and the number when formatting with separation of thousands and decimal numbers does not do it correctly.

Incorrect format
SOLUTION

To solve it we will do the following:

Step 1: Open a terminal, you can use Ctrl + Alt +T

Step 2: sudo nano / usr / share / i18n / locales / es_MX

Once we have entered the password of our user of the command before carried out, the file where we will configure will be displayed, and we look for the section LC_MONETARY, especially on the line mon_thousands_sep «», this line is empty, and only inside the quotation marks will we put the comma «," as shown below:

LC_MONETARY
int_curr_symbol "MXN "
currency_symbol "$"
mon_decimal_point "."
mon_thousands_sep ","
mon_grouping 3;3
positive_sign ""
negative_sign "-"
int_frac_digits 2
frac_digits 2
p_cs_precedes 1
p_sep_by_space 1
n_cs_precedes 1
n_sep_by_space 1
p_sign_posn 1
n_sign_posn 1
END LC_MONETARY

Paso 3: Presionamos Ctrl+O (para guardar cambios), después la tecla enter (para aceptar los cambios) y por último Ctrl+X para salir

Step 4: sudo dpkg-reconfigure locales

The application will open and we will search es_MX.UTF-8 UTF-8 and we will mark it by pressing with the space bar and we will press accept.

Then we will select es_MX.UTF-8 and we press accept as shown in the following image.

Finally, if everything was fine, the result will be displayed as follows.

Final step: We close the session or restart the PC.

The final result can be seen in the initial Image of the article.

As additional information, if we open WPS Spreadsheets and we go to the option Menu-> Options

Posteriormente a «General and save«, Then now we can choose Set decimal symbol as «,» but in our case we will not mark it, this could not be done in version 15.11 of Deepin, in version 20 this was fixed.

Pound sterling correction £

In this second part we will see how to correct or put the dollar sign or any other that is desired in WPS.

1. Write a number.

image

2. Select the currency format

image

3. Right-click on the cell to display the context menu and select Format Cells.

image

4. Select the Custom option

image

5. Now in the Type section: manually change the pound for the peso sign.

image

by

image

6. Done. Press accept and it will be with your Currency format with the dollar sign.

image

I hope it will be of great help to all new users of the Deepin system. This should also apply to the other GNU / Linux distributions.

5 25 votes
Rate the Article
 
Subscribe
Report of
18 Reacciones
More popular
Newer Older
Opinion from the article
See all comments
Эли
Эли (@eli)
Admin
4 meses atrás

Excellent article and very good tutorial @Ppjc72, thank you for your cooperation.

Isaías Gätjens M
Isaías Gätjens M (@igatjens)
Admin
4 meses atrás

Good tutorial, thanks for the input.

Ivan
Ivan (@ivan_23)
4 meses atrás

Good stuff, it has happened to me more than once that is why I always came back to libreoffice, let's see how it goes with this guide.

Frank Alvarez
Frank Alvarez (@franky08)
4 meses atrás

It works wonders, thanks.

ErnestoRyes
ErnestoRyes (@ernestoryes)
4 meses atrás

Well, it turns out very well, thanks for the tutoring.

Ranita
Ranita (@ranita)
4 meses atrás

It works thank you.

Luis Linux
Luis Linux (@ddluislinuxfinal)
4 meses atrás

Great, thank you very much, cash, fix it.

DarioAR
DarioAR (@darioar)
4 meses atrás

thanks for the tutoring, it suits me well.

Yulia Restrepo
Yulia Restrepo (@yuliarestrepo)
4 meses atrás

Very useful, thanks, another reason to use wps.

LeviB
LeviB (@levib)
3 meses atrás

Although wps is popular, I prefer libreoffice.

Antonio Oropeza
Antonio Oropeza (@oropeza2007)
3 meses atrás

Would it be the same to fix it in any version of wps?

Эли
Эли (@eli)
Admin
Respondiendo a  Antonio Oropeza
3 meses atrás

Yo diría que si, pero veamos a ver que dice Cesar

Antonio Oropeza
Antonio Oropeza (@oropeza2007)
Respondiendo a  Céssar
3 meses atrás

Understood thanks Эли Y Cesar by the explanation.

Juan Ospina
Juan Ospina (@juan-ospina)
2 meses atrás

Me funciono cien por ciento, muchas gracias por el tutorial.

Эли
Эли (@eli)
Admin
Respondiendo a  Juan Ospina
2 meses atrás

Qué bueno que le funcionó, es un buen método definitivamente.

César Garcia
César Garcia (@cesargarcia1)
2 días atrás

Hola , el cambio de simbolo de Moneda cambio de la libra esterlina por el signo $ no funcional de manera permanentes , el tutorial aplica por cada celda, no de manera por defecto (default).. somo se lograría de manera fija para todas las hojas y calculo nuevos?

18
0
We would like to know what you think, join the discussion.x
()
x