Losing Text Formatting on Export
I import a lead list from trade shows, and the list is all caps. I use the spreadsheet to make many different modifications (delete unwanted columns an rows, add new data, etc.). I used to use Excel, and converted the caps using the proper() function. I then imported the list into FileMaker, and the records were capitalized correctly.
However, FileMaker Pro 16 (FileMaker is an Apple company!!!) does not support import from Numbers. So I have to first convert the data to title caps in Numbers, save the file as an Excel file, then import the Excel file into FileMaker.
However, when exporting Numbers files (and I have tried all export formats I could use), the cell formatting applied to text (i.e. title caps) is lost, and the text reverts to all caps. Yeah, I could do the formatting in FileMaker, but that is tedious.
Need a short-term workaround, and, longer term, a "preserve text formatting" check box when exporting from Numbers.
Thanks!
MacBook Pro, Mac OS X (10.6.1)