How deal with scientific notation values
Posted on 2013-06-10
I am importing an Excel spreadsheet into a table. One of the columns in the Excel file looks like: (example: 3.91E+11)
3.91E+11 XJ-500 DR JIM OLD US STAMP SCOTT 148 CATALOG VALUE $35
4.00E+11 XJ-501 DR JIM OLD US STAMP SCOTT 159 CATALOG VALUE $23
3.91E+11 XJ-502 DR JIM OLD US STAMP SCOTT 186 CATALOG VALUE $30
4.00E+11 XJ-503 DR JIM OLD US STAMP SCOTT 209 CATALOG VALUE $7
3.91E+11 XJ-506 DR JIM OLD US STAMP 5C JEFFERSON USED NO RESERVE
I hate to admit it but I don't understand what these values are. But I do know that I can't display them this way. They need to be a number field, I guess, but I don't know how to format the values in the table or forms. They are an Item ID field. To make matters worse, as you can see, some of the values are identical yet the description they relate to a not the same.
Can someone help?