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.
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.