+ Reply to Thread
Results 1 to 6 of 6

Typing "12345" and have it automaticly formated to "123.45"?

  1. #1
    Registered User
    Join Date
    07-05-2006
    Posts
    2

    Typing "12345" and have it automaticly formated to "123.45"?

    Does anyone know anything about formatting cells so they would behave like an accounting calculator. As in typing "12345" without pressing any decimal key, and have it use the last two digits as the tenth and hundredth decimal place, ie) "123.45"?

    If it isn't possible, it would be informative to know that as well.

    Thanks a million in advance!

  2. #2
    Chip Pearson
    Guest

    Re: Typing "12345" and have it automaticly formated to "123.45"?

    Go to the Tools menu, choose Options, then the Edit tab. There,
    check the Fixed Decimals setting and choose the number of decimal
    places you want (default is 2).


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com


    "ZenTrickz"
    <ZenTrickz.2aha30_1152112505.7676@excelforum-nospam.com> wrote in
    message
    news:ZenTrickz.2aha30_1152112505.7676@excelforum-nospam.com...
    >
    > Does anyone know anything about formatting cells so they would
    > behave
    > like an accounting calculator. As in typing "12345" without
    > pressing
    > any decimal key, and have it use the last two digits as the
    > tenth and
    > hundredth decimal place, ie) "123.45"?
    >
    > If it isn't possible, it would be informative to know that as
    > well.
    >
    > Thanks a million in advance!
    >
    >
    > --
    > ZenTrickz
    > ------------------------------------------------------------------------
    > ZenTrickz's Profile:
    > http://www.excelforum.com/member.php...o&userid=36061
    > View this thread:
    > http://www.excelforum.com/showthread...hreadid=558475
    >




  3. #3
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996
    Try this:

    From the Excel main menu
    <tools><options><edit tab>
    Check: Fixed decimal
    Set Places to 2

    Does that help?

    Regards,

    Ron

  4. #4
    Chip Pearson
    Guest

    Re: Typing "12345" and have it automaticly formated to "123.45"?

    I should have added that this changes the actual value of the
    cell, not just the displayed value.


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com


    "Chip Pearson" <chip@cpearson.com> wrote in message
    news:ePXtPgEoGHA.4688@TK2MSFTNGP03.phx.gbl...
    > Go to the Tools menu, choose Options, then the Edit tab. There,
    > check the Fixed Decimals setting and choose the number of
    > decimal places you want (default is 2).
    >
    >
    > --
    > Cordially,
    > Chip Pearson
    > Microsoft MVP - Excel
    > Pearson Software Consulting, LLC
    > www.cpearson.com
    >
    >
    > "ZenTrickz"
    > <ZenTrickz.2aha30_1152112505.7676@excelforum-nospam.com> wrote
    > in message
    > news:ZenTrickz.2aha30_1152112505.7676@excelforum-nospam.com...
    >>
    >> Does anyone know anything about formatting cells so they would
    >> behave
    >> like an accounting calculator. As in typing "12345" without
    >> pressing
    >> any decimal key, and have it use the last two digits as the
    >> tenth and
    >> hundredth decimal place, ie) "123.45"?
    >>
    >> If it isn't possible, it would be informative to know that as
    >> well.
    >>
    >> Thanks a million in advance!
    >>
    >>
    >> --
    >> ZenTrickz
    >> ------------------------------------------------------------------------
    >> ZenTrickz's Profile:
    >> http://www.excelforum.com/member.php...o&userid=36061
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=558475
    >>

    >
    >




  5. #5
    Registered User
    Join Date
    07-05-2006
    Posts
    2
    Thanks Chip! Thanks Ron!

    Today you guys are my hero

  6. #6
    Corey
    Guest

    Re: Typing "12345" and have it automaticly formated to "123.45"?

    In any future cases, you might keep in mind that you can simply change
    the formatting of the 'problem' cell. By right-clicking selecting
    Format Cell, you can ensure that the cell you selected isn't set as a
    date, currency, decimal, so on and so forth. Just FYI! Glad they
    resolved the issue for you!


+ 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