save file as .csv

Posted on 2012-08-21
Last Modified: 2012-09-04
I have a template which is in .csv file. One column, I want to format it as Number, decimal place set to 0.  It asked me to save. When click yes, "xxxx.csv may contain features that are not compatible iwth CSV(comma delimited). Do you want to keep the workbook in this format?"

Is this possbile to format cell?
Question by:VBdotnet2005
    LVL 2

    Expert Comment

    There is probably an easier way to do this but here is what I do:

    Once you format it to your liking, try saving it as a txt file. This will preserve the formatting. Reopen the txt file with excel, making sure you use delimited, resave as csv. This will have the newly formatted cell.

    Author Comment

    if account number like

    it turns to 1.11111e+11
    is it possbile to leave it 111111111111 ?

    Author Comment

    I tried to follow your advice above. I could not get it to work.
    LVL 10

    Accepted Solution

    You cannot store cell formatting in a CSV file.

    Excel will save the data in whatever format it determines will allow the values to be reloaded correctly.

    I created a CSV file similar to what you're describing. If 12-digit numbers are displayed with a format of "0" then Excel stores them in the CSV as 12-digit numbers. However, if I re-open the file, the numbers are displayed by default in engineering notation. If I save the file without changing the cell format to "0" then Excel stores the values in engineering notation.

    You could manually run a macro that changes the cell formatting to "0" every time you open the file, but I don't think there is a way to do what you want automatically.
    LVL 6

    Assisted Solution

    you can format data in a CSv file using excel but it will not save the format details i.e. if one column is decimal, nxt is date and so on.

    This is only possible if you save as an excl file.

    CSV are simple files like txt files.
    LVL 7

    Assisted Solution

    I've tried to duplicate your problem but everytime I save as a csv it doesn't change the format of the number.

    What version of Office are you using?

    Try setting the field as text or general before you save as csv and see if this helps.

    Otherwise would you be able to provide a sample spreadsheet in excel that you are trying to save as csv.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This collection of functions covers all the normal rounding methods of just about any numeric value.
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now