Closed Thread
Results 1 to 3 of 3

i am getting decimal value in Round numbers

  1. #1
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    i am getting decimal value in Round numbers

    i am getting decimal value in Round figures number example if i have (1-1/16 --> 1.065)

    but i need it should display(1-1/16 ---> 1.062).......... etc

    how can i do it

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,652

    Re: i am getting decimal value in Round numbers

    I don't understand what you are asking?

    Your code converts 1 - 1/16 IN to 1.0625 IN which seems correct.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,705

    Re: i am getting decimal value in Round numbers

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Round off numbers and remove decimal points
    By bmbalamurali in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-08-2014, 01:14 PM
  2. [SOLVED] Round 2 decimal places
    By Ventoux in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2013, 02:17 PM
  3. [SOLVED] round up to one decimal
    By rcprito in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-19-2013, 07:17 AM
  4. [SOLVED] Round numbers to decimal places
    By bigband1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-01-2013, 11:34 AM
  5. Numbers round down when a 5 is in the third decimal place using a formula
    By Jbagger in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-27-2007, 11:59 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