I need import .xlsx file with numeric cells. Decimal delimiter is comma, in the preview of import numbers are OK – for example 847.09 but after import records are 84709.0000. I didn’t way how import it correctly.
ยจ
Thanks in advance for assistance.
Whenever I import something into TF, I search for all commas and replace them with something else. In your case it sounds easy. Select all and modify the number format to a period instead of a comma.
If that isn’t what you want to do, I export from a spreadsheet to a text (ASCII) file. There I search and replace with whatever is necessary to end up with periods in the right place and commas are in the right place.
Then import into TF as a CSV (comma separated values) file.
Ya, it’s possible that your numbers are in a European format with commas for the decimal point. But Tap Forms should recognize the commas as a decimal point as long as your language and region settings on your Mac are set appropriately.
.
