+ Reply to Thread
Results 1 to 3 of 3

ctrl shift 6 shortcut - change the format you get?

  1. #1
    Registered User
    Join Date
    11-20-2014
    Location
    Vilnius, Lithuania
    MS-Off Ver
    2010
    Posts
    2

    ctrl shift 6 shortcut - change the format you get?

    Hey guys!

    A very short question

    Ctrl+shift+6 is a shortcut to format number to e.g. 10 000 to 1.00 E+04.

    I would like to have this shortcut changed, or in fact any other shortcut so that I would get 10 000 to 10,000

    Currently I go ctrl+1 (format cells), then custom, and then select #,##0 format.

    Is there a way that I could achieve the same result as with ctrl+shift+6 , but get the format I need?

    Thanks in advance

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: ctrl shift 6 shortcut - change the format you get?

    Have you tried Ctrl+Shift+1? You only need to remove the decimals post that
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    11-20-2014
    Location
    Vilnius, Lithuania
    MS-Off Ver
    2010
    Posts
    2

    Re: ctrl shift 6 shortcut - change the format you get?

    Yep, that seems to work.

    It still takes three clicks when theoretically it could only take one...

    Thanks anyway!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 05-26-2015, 10:50 AM
  2. [SOLVED] Assigning a shortcut to ctrl and shift and the number pad
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-18-2014, 04:48 PM
  3. CTRL+F - Shortcut key
    By excelhlp in forum Excel General
    Replies: 1
    Last Post: 08-09-2010, 11:49 PM
  4. [SOLVED] Macro's with Ctrl or Ctrl-Shift?
    By Al Franz in forum Excel General
    Replies: 6
    Last Post: 09-05-2005, 06:05 PM
  5. [SOLVED] In Word the shortcut keys to change from UC to LC is shift F3....
    By jdtrkohler in forum Excel General
    Replies: 1
    Last Post: 04-06-2005, 12:06 PM

Tags for this Thread

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