excel change format of cell

Posted on 2011-04-26
Last Modified: 2012-05-11
How can i change excel format when i change custom to text it will be decimal how can i fix it
Question by:teera

    Author Comment

    this is the excel file
    LVL 50

    Expert Comment


    can you please explain what you want to achieve? Your question is not clear.

    cheers, teylyn
    LVL 85

    Expert Comment

    by:Rory Archibald
    What do you want it to be, exactly? Your data is entered as numbers - are you trying to actually convert them to the displayed text?
    LVL 50

    Accepted Solution

    You could use a formula like


    then copy the result and use paste special > values

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    779 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

    12 Experts available now in Live!

    Get 1:1 Help Now