Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Decimals in Excel

  1. #1
    Guest

    Default

    I have one column in Excel that I want a fixed decimal, when I select the column and
    format it to have decimals it adds two zeros after the decimal. Example I want to enter 5565 and the decimal point would be 55.65, I'm getting 5565.00,how do I get rid of these zeros? I only want this one column to have the decimal. Your help is appreciated.

    Thanks,
    PJ

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,657
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-07 10:55, Anonymous wrote:
    I have one column in Excel that I want a fixed decimal, when I select the column and
    format it to have decimals it adds two zeros after the decimal. Example I want to enter 5565 and the decimal point would be 55.65, I'm getting 5565.00,how do I get rid of these zeros? I only want this one column to have the decimal. Your help is appreciated.

    Thanks,
    PJ
    Enter 100 in een empty cell.

    Copy it.

    Select the values of interest.

    Activate Edit|Paste Special >Divide.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you always put in four digits

    =MID(E1,1,2)&"."&MID(E1,3,2)


    Regards,

    Gary Hewitt-Long

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There is another option that might be useful.

    You can have any particular worksheet have as its default a particular number of
    decimals: Tools/Options/Edit/Fixed Decimal = 2 (or whatever you want).

    This applies to the sheet as a whole. If you want to override it for any particular
    cell, include the decimal in the cell entry
    (i.e., 6442. yields 6442 but 6442 yields
    64.42 if you have 2 decimal places selected.)
    "Interfere? Of course we should interfere! Always do what you're best at, that's what I say!" -- The Doctor, Nightmare of Eden

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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