csv files

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Csv files

Csv files

resolvedResolved · Medium Priority · Version 2010

Matthew has attended:
Excel Intermediate course

Csv files

We are completing a csv file with names and 'phone numbers so we can bulk upload them to the contacts directory of our new phone system. The leading zeros in the phone numbers always disappear when you save the file. Amending the formatting of the cells to Number works but does not save. We are having to get around this by putting an apostrophe before the leading zero but why does the formatting not save?

RE: csv files

Hi Matt,

Your problem looks like it's due to the file being saved as a csv as saving in this format won't preserve any formatting applied. So I would suggest you save it as an Excel Workbook instead.

If the leading zeros have 'dropped off', what you could do is format your cells or column containing the mobile numbers to restore the zeros by doing the following:

1. Select data and press Ctrl 1
2. Select 'Custom' at the bottom of the category list
3. In the 'Type' field type 00000000000 (ie. 11 zeros)
4. Click OK

This will work for mobile numbers with 10 digits missing the leading zero. Once you've done this you should be able to upload it to your phone directory as an Excel file where the formatting is preserved

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips


Server loaded in 0.09 secs.