+ Reply to Thread
Results 1 to 27 of 27

Find and replace in word document

Hybrid View

  1. #1
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Find and replace in word document

    Whenever I link data between and excel and word, I first convert all the numbers to text. For example a simple formula like this:
    Formula: copy to clipboard
    =1/3

    would have a lot of decimal spaces I don't want to show. In Excel, I change the way it is displayed (e.g. 2 numbers after the decimal). I can also use a round, etc. The problem is when you link this cell to Word, it still shows a lot of decimal spaces. The trick is to convert the final number to a text:
    Formula: copy to clipboard
    =Text(1/3,"0.00")


    Hope this helps.

    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  2. #2
    Registered User
    Join Date
    05-14-2013
    Location
    California
    MS-Off Ver
    Excel 2013
    Posts
    78

    Re: Find and replace in word document

    =IF(B5>999999,TEXT(B5,"#,,.0"&"m"),IF(B5>999,TEXT(B5,"#,.0"&"K"),))
    Works for thousands, but if i put in 1,600,000 it gives me a value error?
    Thanks for your help

+ 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.6.0 RC 1