+ Reply to Thread
Results 1 to 5 of 5

need vba on K & L column convert currency to round after dot

  1. #1
    Forum Contributor
    Join Date
    11-25-2015
    Location
    bangalore
    MS-Off Ver
    2019
    Posts
    120

    need vba on K & L column convert currency to round after dot

    Dear experts

    I have set of table from B To L column which contains data particularly K&L column contain number with n number of decimal points currency value
    i want make it roundup in both column till end of row completed of both debit and credit values

    6565656.52565645 value in debit and credit want to change as 6565656.53

    in case row value get adjusted to down it work till before total values

    please find the attachment
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: need vba on K & L column convert currency to round after dot

    Try this code
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: need vba on K & L column convert currency to round after dot

    or

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    11-25-2015
    Location
    bangalore
    MS-Off Ver
    2019
    Posts
    120

    Re: need vba on K & L column convert currency to round after dot

    Thanks experts!! Make my workday simple....Solved

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: need vba on K & L column convert currency to round after dot

    You're welcome
    Thanks for the feedback

+ 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. convert the currency
    By sagar in forum Excel General
    Replies: 3
    Last Post: 11-06-2015, 05:15 AM
  2. [SOLVED] Convert currency
    By cmartin33 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-27-2015, 01:19 AM
  3. Is there a way to round currency?
    By jpowers in forum Excel General
    Replies: 1
    Last Post: 12-27-2005, 12:15 PM
  4. Convert currency to $X.XMM
    By StephanieH in forum Excel General
    Replies: 3
    Last Post: 06-13-2005, 05:05 PM
  5. round currency column up to XX.99
    By sirwreck in forum Excel General
    Replies: 2
    Last Post: 03-15-2005, 11:24 PM
  6. Replies: 4
    Last Post: 01-27-2005, 05:06 PM
  7. [SOLVED] How do I ROUND() round off decimals of a column dataset?
    By H&oslash;jrup in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2005, 07:06 AM

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