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!
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
That's a great idea, thanks Ben!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks