Results 1 to 6 of 6

Excel 2007 : showing .260 instead of .26

Threaded View

  1. 08-19-2011, 01:12 PM #1
    jimb01
    jimb01 is offline
    Registered User
    Join Date
    06-08-2011
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2007
    Posts
    23

    Exclamation showing .260 instead of .26

    How do I show the zero in the thousandth postion in a decimal. I have the cell formatted as a number to show 3 decimal places. I am required to it as .260 not rounded off to .26. This is the answer to a calculation. the cell value is not always .260. many times it is 3 numbers in the decimal without a zero, ie. .123

    Thank you
    Last edited by jimb01; 08-19-2011 at 01:15 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1