+ Reply to Thread
Results 1 to 2 of 2

Decrease Decimal

  1. #1
    Forum Contributor
    Join Date
    12-12-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    448

    Decrease Decimal

    Hi. The shortcut for decrease decimal is Alt-H-9, but that only does it once. Let's say I would like to decrease the decimal 4 times, is there a way to do this without clicking Alt-H-9 four times (I also don't really want to hit control-1 and change formatting) Thanks.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Decrease Decimal

    Any good for you?

    CTRL+$*Applies the Currency format with two decimal places (negative numbers in parentheses) .*
    CTRL+%*Applies the Percentage format with no decimal places.*
    CTRL+^*Applies the Exponential number format with two decimal places.*
    CTRL+#*Applies the Date format with the day, month, and year.*
    CTRL+@*Applies the Time format with the hour and minute, and AM or PM.*
    CTRL+!*Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.*

+ 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