Use 1000 separator(,) is not working correctly

Question

Use 1000 separator is not working correctly, some values is right, other have no comma.

I added an image and the sample file in the below link.

I use OS Windows 10 and Office version 2021.

Hope for your response!

Thanks!

https://docs.google.com/spreadsheets/d/12WLltoE8FHDR9LctSDcdxooLqsTNbvTT/edit?usp=sharing&ouid=112310544159929632856&rtpof=true&sd=true

riny_van_eekelen · Answer

littlevillage&nbsp;Select the entire column and set the format you want. It shall work. See attached.&nbsp;

sergeibaklan · Answer

littlevillage&nbsp;
Some values are texts, not numbers (TRUE in attached)

littlevillage · Answer

Hi Riny_van_EekelenThanks for your answer,I tried to do the same way but its still not work

littlevillage · Answer

Hi SergeiBaklanThanks for your responseI tried to do next what you mentionned,In the file attached, for example, the input is 500000,&nbsp;the expected result is 500,000&nbsp;but&nbsp;the outcome at the moment is 500.000. its still not work.

Forum Discussion

Use 1000 separator(,) is not working correctly

4 Replies

Resources