bespoke.computing wrote:

How do I get numbers to open a csv file that has a column of phone numbers and stop the imported data from dropping the leading zero?

Thank you Hallway, this worked! Also, a great tip on remembering how data is rendered via opening files in txt or excel/csv. I need to get better at asking the third party who is receiving the data if they are able to extract the data from txt files where the leading zeros are clear or if they are pulling the data straight from the spreadsheet.

Try explicitly formatting the column(s) in Numbers as Text (rather than leaving them as Automatic), then copy-paste from Excel. Usually that works. If that still results in dropped leading zeros, try formatting all the columns in Numbers as Text first. You can also try Edit > Paste and Match Style if you're still having trouble.

I have used OpenOffice on both platforms, both with exactly the same processor speed, and the PC practically rolled over and died trying to run it. Not forgetting the cross platform packages GIMP and OpenOffice, both available for Mac and PC (amongst others). We are merely a software download directory and search engine of shareware, freeware programs available on the Internet.Reflex Xtr Mac Os XHowever report a problem you have had with any individual software listed here and we will delete it promptly. Reflex xtr for mac. Note: Remember to virus scan all software before you install, and be sure to read and agree the software License Agreement.: Greetings,:: I'm looking for a list, as long a list as possible, of software that: runs on Mac OSX.

Just opening a CSV file seems to always drop the leading zeros.

SG

Nov 4, 2015 12:29 PM