When I upload contents from excel file, characters 'E5','E4' or 'E3' are changed automatically to '00000','0000' or '000'. How can I fix it?
I guess you mean "import" or "convert" rather than "upload", and your data have number before those text like
I didn't find answer for using Excel file, save it as text (csv etc.) can be workaround.
Yes. You are right. For example, I imported code of "24047108651E5". As I designated the field as text, I thought it would be imported as text. But Filemaker recognized it as number.
It thinks it is using Scientific (exponential) Notation
I agree. You may need to change the way you pass the value.
And i also reported this issue here :
Are some text data impossible to import correctly from an Excel file ?
Sounds like FileMaker PRO is "guessing" the cell type by analyzing its content, instead of reading the Excel cell type.
I don't seem to be able to reproduce this using FMPA16.0.5 (neither Mac nor Windows).
Are you able to upload your Excel file here? I notice from the screen shot you have the green corner flag indicating an error in the formula.
It is not real error, entering the exact text in cells formatted as text.
I don't want to enter such text as calculation on standard general formatted cell, like
but after doing it, FM convert (drop the .xlsx file on FM window) it to
Now I saved it as ancient (Excel 97-2003 book) format .xls, it succeeded! (But it is not so different than saving it as csv...)
Thank you for your post.
As mentioned by "Fred(CH)", our Development and Testing departments are aware of this issue. I have attached your post to the original report. When more information becomes available, I will post again.
Thank you very much. I have another issue regarding style of types. I can change styles of types in revision mode but only on English style of types not on Korean styles of types. Even though style is changed into certain styles in indication, it is changed into certain pre set style automatically when I begin to type in. I cannot find any method to change the preset style of Korean characters.
Won Sik Kim
2018. 4. 26. 오후 11:57, TSGal <email@example.com<mailto:firstname.lastname@example.org>> 작성:
Re: Excel file upload
reply from TSGal<https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.filemaker.com%2Fpeople%2FTSGal%3Fet%3Dwatches.email.thread&data=02%7C01%7C%7Cc1962d7f18eb4e7f52bc08d5ab86049d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636603514458948170&sdata=3AXDNkCvlZIaBQsO89mQC1X8oNrrCXMgx%2FX3kv8mkSs%3D&reserved=0> in Report a Product Issue - View the full discussion<https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.filemaker.com%2Fmessage%2F757619%3FcommentID%3D757619%26et%3Dwatches.email.thread%23comment-757619&data=02%7C01%7C%7Cc1962d7f18eb4e7f52bc08d5ab86049d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636603514458948170&sdata=zjTnuagqxEuZOmEw9aTa20yiyXe%2FWEw2I2%2Fm4L1v9a4%3D&reserved=0>
Retrieving data ...