Hello ! I have incorrect formats in the below table that i want to correct. The fields in red are incorrect and want them changed as shown in the table I want the output for the first 3 rows changed as shown in desired output. Field OutputDesired Output 21.840.0002221,840,0001.077.719.25511,077,719,2551.012.065.60011,012,065,600287.245287 123456789123,456,789 1234512,345 170027800170,027,800 123.456123

formatting numbers

Hello !

I have incorrect formats in the below table that i want to correct. The fields in red are incorrect and want them changed as shown in the table

I want the output for the first 3 rows changed as shown in desired output.

Field	Output	Desired Output
21.840.000	22	21,840,000
1.077.719.255	1	1,077,719,255
1.012.065.600	1	1,012,065,600
287.245	287
123456789	123,456,789
12345	12,345
170027800	170,027,800
123.456	123

Data Investigation

Accepted answers

All comments

binay2448

Find my solution...

Formatting numbers.yxmd

Abhii2658

Thanks @binay2448

But 287.245 should be 287 and not 287,245.

Abhii2658

Similarly, 123.456 should be 123

binay2448

How should we can differentiate decimal before last 3 digit numbers in these cases

shreyanshrathod

@Abhii2658 , How are you determining that 287.xxx should be 287 and 1.234.xxx.xxx should be 1,234,xxx,xxx?

The way I see it then, you have to apply a conditional formula (IF statement) and replace "." with ",".

Regards,

Shreyansh

Elias_Nordlinder

Hello @Abhii2658 ,

Here is one way I did that could solve your problem as you state it at the moment.

But as other says, it depends on how you decide to differentiate between 287.245 and the other numbers.

(I took it as 287.245 in the beginning means 287,245, which is rounded to 287,
while 12,345 means 12 346, which can be written as 12.346.
So all numbers that have specifically "One Dot" is actually in the hundreds and have decimals written out, while all the other numbers does not.)