remove last 3 digits from a number

[jmsm]

Hello.

I have an excel file that have a field in a number format. The entries are like "703007082618934000". I have a local table that is my destination table and this field has data type "number", field size "double" and format "0".

The problem is that I need to remove the last 3 zeros (when appending a new file from an append query) from these numbers and I can't figure how. I tried left, len but it won't work.

Any suggestions? Do I need to change to text format and perform a trim? The problem is that I need in number format with the all digits and not e^17 format.

Thank you.

 

[theDBguy]

Hi. Have you tried maybe dividing by 1000?

 

[jmsm]

Hi. Have you tried maybe dividing by 1000?

No, and it worked! I did a lot of testing and it was a single solution.

Thank you!

 

[theDBguy]

No, and it worked! I did a lot of testing and it was a single solution.

Thank you!

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.