Concatenate two cells, adding a decimal and leading zeros

[frustrated_macro]

Hi, i need to take two cells and convert them to a decimal, but i always need 3 zeros to the right of the decimal - like so

Property ID	Eps #	expected results
260638​	3​	260328.003​
220999​	1​	220999.001​
260142​	6​	260142.006​
220689​	4​	220689.004​
171039​	8​	171039.009​
171039​	10​	171039.010​

how can i write that into a macro?

 

[Joe4]

If columns A and B are both numeric entries, an easy way is this:

=A2+(B2/1000)

 

[frustrated_macro]

If columns A and B are both numeric entries, an easy way is this:

=A2+(B2/1000)

ughhh DUHHHH
thank youuuuuuuuuuu

 

[Joe4]

You are welcome.
Glad I was able to help!