Add decimal point to string

[DeeEll]

Hi guys

Great forum and some really interesting reading.

I can use formula =SUBSTITUTE(A2,(LEFT(A2,3)),(LEFT(A2,3)&"."))
to add a decimal point in this product code

start 992709 result 992.709

Can anybody free/charge help me with
start 1318241 result 1.318.241


Thanks
David

[martindwilson]

try
=SUBSTITUTE(TEXT(a1,"#,##0"),",",".")

[DeeEll]

Works a treat. Many thanks.

David

[popipipo]

Or just change celformat in #.###

[DeeEll]

Hi Willem.

Thanks for the input. I did try your solution and it works fine for a comma (,) delineated number but a decimal point (.) always shifts to the right.

David

[Jonmo1]

Perhaps

=REPLACE(A2/1000,2,0,".")

[popipipo]

Must be a language problem
In the Netherlands we use the point (.) as thousand separator