+ Reply to Thread
Results 1 to 3 of 3

Thread: Tip - Quick Keypad Commas (for numbers) in Word

  1. #1
    Registered User
    Join Date
    10-28-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Tip - Quick Keypad Commas (for numbers) in Word

    I have to transfer numbers from Excel into Word tables each month (accounting reports). The mail merge just doesn't work properly, so it's a manual process. The problem is, there is no comma on the keyboard's keypad. Every time you need to put a comma in, you have to jump over to the main keyboard and it slows you down.

    So, I came up with a workaround. In each place where you need a comma, simply type ** twice (hit the multiplication key twice). Once you are done entering numbers, simply Find and Replace the ** with a comma. Ensure you don't use ** in your document. If you are really feeling technical, you can record a macro to do the same.

    The trick works GREAT and has saved me a ton of time producing the financials each month!!! If anyone else has any ideas to do the same thing (other than copying the Excel sheet with formats and pasting as a picture), please share!!!

    Take care!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    MSO2007 on WinXP/MSO2000 on Win7/winXP
    Posts
    2,177

    Re: Tip - Quick Keypad Commas (for numbers) in Word

    To avoid having to find and replace, just create an Auto Correct entry. That way the replacement will be made as you type the numbers
    ---
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    10-28-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Tip - Quick Keypad Commas (for numbers) in Word

    That's a great idea, thanks Ben!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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.2.0