Adding dots in last 3 numbers

[Kiuzer]

Hello im really new at excel just finding out ways to make this job easier and faster, got 100+ number to add dots in the last 3 numbers
is there any way that i can do it faster in excel?
Thankyou so much

 

[dreid1011]

Maybe this:

=LEFT(A1,LEN(A1)-3)&"."&RIGHT(A1,3)

 

[KRice]

If you’re dealing with numbers, just divide by 1000.
…and if you don’t want a separate formula that performs the dividing, then consider dividing the numbers in place. To do that, enter 1000 anywhere on your worksheet. Copy it to the clipboard. Then select your list of numbers and choose Home>Paste Special then select the Divide option. Your list of numbers will be divided by the value in the clipboard. Then ensure the numbers are formatted to show three decimal places. The 1000 entry can then be deleted.

 

[Kiuzer]

Thanks!

 

[KRice]

We're happy to help. Welcome to the Mr Excel forum!