Add decimal separator

[Pampos]

Hello. I have copied some numbers of a site to excel. The problem is for example, in the site the number was 5.031 but in excel the number is copied as 5031. Any ideas what can I add the decimal separator The three last numbers of each number are decimal places.

5031 --> 5.031
10203 --> 10.203
204539 --> 204.539

 

[deciog]

Pampos

Try custom formatting ## 0.000

Decio

 

[Pampos]

Thanks!

 

[NARAYANK991]

Hi ,

You need to be clear on what is to be done.

A custom format will only change the way the cell contents are displayed ; thus , you can use custom formatting to display 5031 as 5.031 , but when you use the cell contents for further processing , the value that will be used will be 5031 and not 5.031

If you wish to change the cell value , you will have to introduce formulae in another cell to divide this value by 1000 , and then use this processed value for further operations.

Narayan

 

[Pampos]

Yes, it was so easy. Thanks.