+ Reply to Thread
Results 1 to 3 of 3

How to clear decimal point?

  1. #1
    Michael
    Guest

    How to clear decimal point?

    I'm a Windows 98 user. When I key in 12345, it will automatically display as
    123.45. I have check the cell format, is set to normal. I suspect is due to
    the regional settings that cause this happen. Please advice.

  2. #2
    Nick Hodge
    Guest

    Re: How to clear decimal point?

    Michael

    Tools>Options>Edit>Uncheck Fixed Decimals

    --
    HTH
    Nick Hodge
    Microsoft MVP - Excel
    Southampton, England
    [email protected]HIS


    "Michael" <[email protected]> wrote in message
    news:[email protected]...
    > I'm a Windows 98 user. When I key in 12345, it will automatically display
    > as
    > 123.45. I have check the cell format, is set to normal. I suspect is due
    > to
    > the regional settings that cause this happen. Please advice.




  3. #3
    Guest

    How to clear decimal point?


    Try:
    Format:
    Cells:
    number:
    Decimals
    Clear the number of decimals to zero
    that should work
    >-----Original Message-----
    >I'm a Windows 98 user. When I key in 12345, it will

    automatically display as
    >123.45. I have check the cell format, is set to normal.

    I suspect is due to
    >the regional settings that cause this happen. Please

    advice.
    >.
    >


+ 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