+ Reply to Thread
Results 1 to 6 of 6

Cell Format Problem

  1. #1
    Registered User
    Join Date
    06-02-2009
    Location
    Monterey, CA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Cell Format Problem

    When I enter 3 into a cell, it returns .03. What can I do?

  2. #2
    Registered User
    Join Date
    06-08-2009
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2003
    Posts
    6

    Smile Re: Cell Format Problem

    2003
    Select the cell in question then click

    Edit >> Clear >> Formats

  3. #3
    Registered User
    Join Date
    06-08-2009
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2003
    Posts
    6

    Smile Re: Cell Format Problem

    2003
    Select the cell(s) in question and then click

    Edit >> Clear >> Formats

  4. #4
    Registered User
    Join Date
    06-02-2009
    Location
    Monterey, CA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Smile Re: Cell Format Problem

    I'm using Excel 2007, and there doesn't appear to be any 'Edit/Clear/Formats' button? All I did was highlighted the cells, and went to Data/Format/and entered a number with no decimals, but it didn't help?

  5. #5
    Valued Forum Contributor
    Join Date
    11-11-2008
    Location
    Euro
    MS-Off Ver
    2007, 2010
    Posts
    469

    Re: Cell Format Problem

    + Press Office button --> then press Excel options button

    + Select Advances

    + Uncheck option Automatically insert a decimal point

    -------
    see more information about Automatically insert a decimal point (Ref: Ms.help in excel 2007)

    Automatically insert a decimal point Select this check box to display a number with decimal points by default.

    Places Enter the number of decimal places in the Places box to indicate where Microsoft Office Excel automatically places the decimal point in the numbers that you type as constants on a worksheet. A positive number moves the decimal point to the left; a negative number moves the decimal point to the right. If the Places box is left blank or is set to 0 (zero), you need to enter the decimal point manually. To override this option, type a decimal point in the cell when you type the number.

  6. #6
    Registered User
    Join Date
    06-02-2009
    Location
    Monterey, CA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Cell Format Problem

    I did what you recommended, but now when I insert a numeric value in a cell, and go to another cell, the original cell has 0 in it?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1