I tried to copy and paste a selected area from Excel and the numbers do appear (that were calculated in excel through formulas), however the formatting is lost. We are working on an annual report and having the formatting and the totals in the numbers come through, will save huge amounts of time.
The format that the numbers are in excel are "accounting". When the doc comes through from excel an Ê comes between each of the numbers. If I save the numbers in excel to "numbers" version and re-import they appear all nexto one another.
Accounting = 12Ê867Ê002, General= 12867002, what I'm looking for = 12 867 002