randini Posted April 12, 2006 Posted April 12, 2006 I am using FM7 and and am new to it. I created a very simple database and am entering upc codes in a numbers field. After I enter the UPC code, the numbers automatically change and all the upc fields end with the string "e+09" If I click on the field, the numbers will display as I inputted them, but will change back as soon as I click away. Is this some sort of indexing thing? I just want to be able to recheck my numbers without having to click on each field. Thanks Randy
Fitch Posted April 12, 2006 Posted April 12, 2006 Your big number is getting converted to scientific notation. Select the field in Layout mode, choose Number... from the Format menu, and set it to leave data formatted as entered.
randini Posted April 12, 2006 Author Posted April 12, 2006 Fitch Thanks very much for the quick reply. I knew it was something simple that I had overlooked.
Recommended Posts
This topic is 6862 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now