+ Reply to Thread
Results 1 to 3 of 3

Mround

  1. #1
    Registered User
    Join Date
    01-18-2013
    Location
    Conifer, CO
    MS-Off Ver
    Excel 2010
    Posts
    26

    Mround

    I need to use the mround function on an entire spreadsheet without messing up the data. I

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

    Re: Mround

    I guess you would have to modify each occupied cell in the worksheet.

    So you would need to use a macro.

    The macro would select every numerical cell. which is easy to do if you use the select special function.

    You would then wrap your mround function around the cell formula. ( deleting the existing "=" sign first )

    Is that what you need?

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Mround

    Looks like you hit "Post" before you completed your question?

    Maybe use a helper sheet and apply the mround that way?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. How do I add MROUND
    By STU22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2013, 07:53 PM
  2. Use of Mround
    By chandan12 in forum Excel General
    Replies: 1
    Last Post: 08-17-2007, 02:58 PM
  3. [SOLVED] IF & MROUND
    By phuser in forum Excel General
    Replies: 3
    Last Post: 06-27-2006, 09:25 AM
  4. [SOLVED] MRound
    By Lucky_guy2000 in forum Excel General
    Replies: 2
    Last Post: 04-21-2006, 08:45 AM
  5. Mround
    By ynissel in forum Excel General
    Replies: 1
    Last Post: 06-02-2005, 01:05 PM

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