remove last 3 digits from a number (1 Viewer)

jmsm

New member
Local time
Today, 07:08
Joined
Oct 1, 2020
Messages
12
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

I’m here to help
Staff member
Local time
Yesterday, 23:08
Joined
Oct 29, 2018
Messages
18,972
Hi. Have you tried maybe dividing by 1000?
 

jmsm

New member
Local time
Today, 07:08
Joined
Oct 1, 2020
Messages
12
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

I’m here to help
Staff member
Local time
Yesterday, 23:08
Joined
Oct 29, 2018
Messages
18,972
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.
 

Users who are viewing this thread

Top Bottom