Forum Discussion

Copper Contributor

Jan 22, 2024

I want to change all this values

Rank Name Platform Year Genre Publisher NA_Sales EU_Sales JP_Sales Other_Sales Global_Sales 1 Wii Sports Wii 2006 Sports Nintendo 41.49 29.02 3.77 8.46 82.74 2 ...

BI & Data Analysis

excel

Formulas and Functions

power bi

Riny_van_Eekelen

Platinum Contributor

Jan 22, 2024

Igorfm7 What does that mean "It doesn't work"? What did you try exactly?

Igorfm7

Copper Contributor

Jan 22, 2024

Riny_van_Eekelen

Rank	Name	Platform	Year	Genre	Publisher	NA_Sales	EU_Sales	JP_Sales	Other_Sales	Global_Sales
1	Wii Sports	Wii	2006	Sports	Nintendo	41,49	29,02	3,77	8,46	83
2	Super Mario Bros.	NES	1985	Platform	Nintendo	29,08	3,58	6,81	0,77	40
3	Mario Kart Wii	Wii	2008	Racing	Nintendo	15,85	12,88	3,79	3,31	36
4	Wii Sports Resort	Wii	2009	Sports	Nintendo	15,75	11,01	3,28	2,96	33
5	Pokemon Red/Pokemon Blue	GB	1996	Role-Playing	Nintendo	11,27	8,89	10,22	1	31

I don't want that like this.

What i want is:

Rank	Name	Platform	Year	Genre	Publisher	NA_Sales	EU_Sales	JP_Sales	Other_Sales	Global_Sales
1	Wii Sports	Wii	2006	Sports	Nintendo	41,490	29,020	3,770	8,460	82.740
2	Super Mario Bros.	NES	1985	Platform	Nintendo	29,080	3,580	6,810	0,770	40,240
3	Mario Kart Wii	Wii	2008	Racing	Nintendo	15,85	12,88	3,79	3,31	36
4	Wii Sports Resort	Wii	2009	Sports	Nintendo	15,75	11,01	3,28	2,96	33
5	Pokemon Red/Pokemon Blue	GB	1996	Role-Playing	Nintendo	11,27	8,89	10,22	1	31

Look at the first two lines.

Igorfm7
Copper Contributor
Jan 22, 2024
And in my office, the decimals are like this:

xx.xxx,xx.

I just want to set one more 0 at the right side of the numbers and when the number is 1 for example in line 6, I want to add three zeros. Because this 1 means 1 thousand. Do you get me right now? Maybe I wasn't clear enough on the last messages.
- Riny_van_Eekelen
  Platinum Contributor
  Jan 22, 2024
  Igorfm7 I understood that, but you need to transfer the texts to numbers first. Did you do the Find & Replace as I suggested? Did you change the column format to Numbers?
  
  But perhaps we need to go back to square one. How did you import the CSV? just by double clicking on the file or a did you you use the text wizard?
  - Igorfm7
    Copper Contributor
    Jan 22, 2024
    Riny_van_Eekelen
    
    I'll send a video.
    
    Look, i don't want to see numbers with 2 decimals, btw i want to see them as xx.xxx just, because i guess the owner of the csv made that in thousands and don't wanted to make ''right'' the xx.xx.
    
    https://youtu.be/JVMrV6xTxcE