If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conversion Problem - Text to Exponential
I know that the Subject might be a little off, but here's my issue.
I am importing data from a spreadsheet into an Access database. In this particular column of data, the data looks like this: 911B00, 91FT20, 911000, 91E000. My issue is that when I import that column if data, for some reason it takes the records with a "E" (like 911E00) and displays them as exponential numbers and displays "9.10E+01" - how can I prevent Access from doing that - or what function can a put in a query to fix that? |
Thread Tools | |
Display Modes | |
|
|