Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Filemaker to Excel – Field Properies


Recommended Posts

When I export a Table with connected referenced fields from another table, the field properties in Excel are not "Standard" and show only ######### etc.


What could be the reason for this...?






Link to comment
Share on other sites

It is part of the design of Excel...although I don't know if it is intentional or not. Plus, I haven't totally figured out the reason. The excel help file references only being able to display 1024 characters...but I have cells do it without being over 400 characters... EDIT: Excel limits displaying characters to 255 character.


There are a couple of ways around it. Depending mainly on your skill level with excel and the nature of the field.


1. Change the cell's format to "General" instead of "Text". I believe it comes out of FM with the text format. Sometimes this is all you need to do (could make a macro to automate this task for you, if you do it alot). Cheers!


2. Insert a hard enter (Alt-Enter) every 80-100 characters.


3. Shorten the text in the field. If you can divide a field into smaller fields, you could go that way.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use