+ Reply to Thread
Results 1 to 3 of 3

ROUND not showing trailing zeros

  1. #1
    Registered User
    Join Date
    03-29-2020
    Location
    USA
    MS-Off Ver
    MS Office 2016
    Posts
    12

    ROUND not showing trailing zeros

    I've been scouring the interwebs and beating my head against my desk for an hour trying to figure this out!
    I have a value, myValue, that I want to round to one decimal place (i.e. 78.937466 to 78.9). Using the function round(myValue,1) works, unless the first decimal is zero. For example, 79.027 is displayed as 79, not 79.0.

    How the heck do I fix these?!?!?!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,489

    Re: ROUND not showing trailing zeros

    Format the cell to number->fixed->1 decimal place (number format code "0.0").
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-29-2020
    Location
    USA
    MS-Off Ver
    MS Office 2016
    Posts
    12

    Re: ROUND not showing trailing zeros

    Crap! I had that as General Number. You're the best around!

+ 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. [SOLVED] Keep trailing zeros, but only if they're there...
    By rbrian in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 12-02-2013, 10:47 AM
  2. Remove trailing zeros?
    By arreferee in forum Excel General
    Replies: 1
    Last Post: 01-14-2013, 09:00 PM
  3. [SOLVED] Add Trailing Zeros
    By sweetkel23 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-07-2012, 01:42 AM
  4. [SOLVED] Delete trailing zeros.
    By krasher in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 09-21-2012, 10:43 AM
  5. Replies: 5
    Last Post: 04-09-2012, 02:28 PM
  6. Remove trailing zeros
    By Garren1013 in forum Excel General
    Replies: 10
    Last Post: 02-21-2011, 05:08 PM
  7. Leading and trailing Zeros
    By Buratti in forum Excel General
    Replies: 0
    Last Post: 09-16-2009, 02:27 PM
  8. trailing zeros
    By htorres in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-23-2007, 03:00 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