Results 1 to 6 of 6

changing the decimal places without rounding the numbers

Threaded View

  1. #1
    Registered User
    Join Date
    01-08-2009
    Location
    Makati City, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    8

    changing the decimal places without rounding the numbers

    Hi everyone,

    I hope you guys can again help me with my Excel issue.

    I was trying to decrease the decimal places of the data figures that I'm currently working on my report, however, it keeps rounding-up the decimal numbers. I wish to keep the original numbers and just decrease the decimal places.

    For example:
    The original figure is = 7260.12903225806
    Upon decreasing the decimal figures to just 2, the result became = 7260.13

    Is it possible for me to just have this result = 7260.12 instead of 7260.13?

    I've tried using the TRUNC formula butit does not work if the 2nd decimal value is 0.

    For example:
    The original figure is = 227161.905808985
    Upon applying the formula, the result became = 227161.9 instead of 227161.90

    Again, thank you thank you guys in advance for your usual help
    Last edited by the_reporter; 03-19-2009 at 06:02 AM.

Thread Information

Users Browsing this Thread

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

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