Ideate BIMLink exports numeric Revit property values to Excel using the default units defined within Revit. If the default unit in Revit is set to feet and fractional inches, Ideate BIMLink will export the value as a decimal value with three places. Numerical values imported from Excel are also interpreted as having the default units defined in Revit.
See Revit menu: Manage tab ►Settings panel ► (Project Units)
NOTE: Revit's Properties palette does NOT use the unit format specified within Project Units. It has its own, hard-wired format.
Excel does not support imperial format for length values in the same way that Revit does, with both the feet and inches syntax. Therefore, when dealing with Imperial length units, feet and fractional inches are displayed as decimal feet, and fraction inches are displayed as decimal inches. Even though the values are exported using numerical values, for importing purposes, these number formats are acceptable: 6'1 or 73" or 6'-1".
Excel will try to automatically convert certain types of text string data into the Date format if an edit is made. For example if you type in 3-03-12 it will change the Cell format from "General" to "Date" and will also change the underlying cell value. Unfortunately this also alters how the information is imported back into Revit via Ideate BIMLink. In these situations there are two recommended workarounds.
Thank you for taking time to inform us about a bug or feature request.
If you'd like to upload a file to help explain the issue, you can upload a file to Hightail.