Mac OS X | | Mesa | can't export "Text" numbers.

Mesa

Excel-compatible spreadsheet app

Version: 3.1

[ Views: 513 ]

can't export "Text" numbers.

Feedback Type: Review

Contributed by: paul_reading_uk Wednesday, August 27 2003 @ 04:26 AM PDT

Product Platform: MacOSX

Used Product For: Have Not Tried

Recommend Product: YES

I have been trying to export a CSV file of telephone numbers, unfortunatly it changes them for 4.11e10 etc and there is no workaround :(

Rate this Review

Was this Review helpful? Yes | No

Comments

can't export "Text" numbers. - Mac OS X Fan

If the numbers are entered with spaces or dashes etc within them (eg 1234 56789), then Mesa knows they are text and exports them to CVS as such. But if you have entered them as 'pure' numbers - (eg 123456789) then as far as Mesa is concerned it is a very large number and gets exported in the format you saw. The best workaround might be to just edit the phone numbers and put a single quote ' at the front of each number. This converts them to Text, which means that they will export to CVS fine.

Hope that helps.

Reply to This

Saturday, August 30 2003 @ 07:29 AM PDT