Importting incorrectly

G

Guest

I have a text field in which I am importing 1021245 (excel
file). But, it comes thru as 1.02125e+006. I have tried
a lot of things...to no help.

Can someone tell me how I can correct this?

Thanks
 
M

Marshall Barton

I have a text field in which I am importing 1021245 (excel
file). But, it comes thru as 1.02125e+006. I have tried
a lot of things...to no help.
Click to expand...

Those look like the same numbers to me, just formatted
differently. If you are not explicitly using a scientific
notation format, then make the text box (or sheet column)
wide enough to display the entire number.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Disable Outlook AutoCorrect with GPO 0
How to set tabs in work document 0
Importing styles not updating document 1
Autonumber field in Excel that behaves the same as Access 0
Automation of scanned file storage based on content 0
You don't currently have permission to access this folder 0

Top